Re: Indexing issues, help

> Can anyone clear me up about index, clustered index. > > 1. What is the best timing to use clustered index? If you have a really big table which you need to process in index order. > 2. index A and index B has the same indexing columns but different order, > such as (a, b, c) and (c, b, a), where a, b, c are columns. > Will ithe proformance make difference that the table has these two > index toghther? No. You may need both indexes, and if so, you should have both. > 3. What is the best indexing stradegy? Who knows? Each site / app has its own requirements. I have run some benchmarks which showed me no improvement in performance if I used a CLUSTERED index, but YAMMV, etc. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+ | A WAY COMPUTERS CHANGED THE WORLD: 1 million banking errors | +------------------------------------------------------------------------------+