Re: optimized searching - need desperate help

[Ankur Saxena]

Hi Jay,

Thank you so much, it did the trick. The indexing was the one which solved the problem. I am not very familiar with indexing, but how do I decide to make index or not. This is really helpful, infact the query was responding in 0.00 sec, which is phenominal, now I have 1.1 million records and still the response, even if it is in the .1 sec range I am happy.

Again how do I find more about optimizing my Database designs for the type of queries I perform. Like in this case you mentioned the index, can you suggest some place where I can do a quick read.

Also I dont need to recreate indexes right, once done any amount of data I put in will always be indexed. Also how does it really help to index and what are the negatives of index?

Thanks
Ankur