Hello,

Out of curiousity, when an index is rebuilt, does the rebuild process draw
on existing indexes if applicable ?

For example ...

I have an index on PRODUCTID,OUTLETID,STATUS,VALUEDATE.
I want to create an index on PRODUCTID,OUTLETID,VALUEDATE.

or

Idx #1 : PRODUCTID,OUTLETID,VALUEDATE
Idx to create : PRODUCTID,OUTLETID,VALUEDATE,STATUS

Will index #1 be used to speed up processing ?

--
Jerome Bouvattier