Hi,

> 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 ?

No and i'm wondering if it really would speed up. The other index probably
holds also index-entries which are not "valid", so you would copy them too.
Always a memory sort is made from the fields you selected for the index and
the index is rebuild from that.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81