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
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.