From: Ahmet DÜLGAR (dulgarhotmail.com)
Date: Mon Jan 05 2009 - 15:42:12 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

hi everyone
my question is about tables
i have lots of records
i want to learn that if i slip my record. are the select run more fast
for example
table1
name surname place
aaaa bbbbbb x
qqqq xxxxxx x
asdw sdfjsd x
aqq asdas y
aqq asdas y
aqq asdas y
aqq asdas y
 
my query is selec * from table1 where place=x
or
selec * from table1 where place=y
all the query is this
but there is too much record
if i make 2 table and
i add x records to table1
and
the y records to table2
so i dont use where cause
 
is it faster than the first model
 
i want to learn this
my example is simple
i couldnt chooise which one i should use
i have 2 different table but column and values are same
they are different because value is are different
if i make all in one table
is it same fast like model one
 
please help me
sorry about my english
 
best regards
_________________________________________________________________
Windows Live Messenger'ýn için Ücretsiz 30 Ýfadeyi yükle
http://www.livemessenger-emoticons.com/funfamily/tr-tr/

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]