Page 1 of 1

index and key's

Posted: Wed Feb 09, 2005 9:29 am
by pelegk2
what is the meaning of a col that had a key and whats the diffrence if its a key or a an index?
what is a "smart" way ti use it on queries?
thnaks in advance
peleg

Posted: Wed Feb 09, 2005 10:11 am
by feyd
keys and indexes are roughly the same. Using indexed columns speeds up searches, however indexing every column won't help much.. as you are demanding more of the server.