Re: Choosing Indices

> > Is there a way to choose the main index that you want to search on? > Actually no, the optimizer will chose the lowest cost method to access the data regardless of the order of the where clause. The only way to fool it would be to drop the index you do not wish the optimizer to use but that will likely cause a sequential scan of the table. Mike.