Hi, I need to optimize/speed up my 'select' queries. The query creates about 3 to 6 left joins from 7 different tables depending on the different conditions passed. The problem is that this is taking a lot of time.
The table column's are of both varchar and integer types - on which comparisions are done to collect the final data. Could you advise me on how to create indexes to speed up my queries. 1. A little background on how indexes work - or a link containing info on this. 2. Do I need to create an index on each column for each table or create an index for each table on all of its columns? 3. Please note that the columns on which comparisions are done are of varchar type also so do indexes work on them as well? 4. Any other suggestions which the experienced folks would have come across. Thanks and Regards, Ritesh Kapoor Atrenta Pvt. Ltd.
