There's nothing in compound indexes itself that would increase a chance of corruption but they do increase size of the index file itself. Did you look into other ways to improve performance?
>
>We are using compound indexes to improve our data access speed which has improved. We are sometime getting our indexes corrupted and don't know if it's related.
>Does anyone have any experience or knowledge about the "does and don'ts" of using compound indexes? Are they OK to use or are there reliability issues.
>
>Examples of indexes I'm using:
>
>*----- Views Defined for Compound Indexes
>INDEX ON STR(iCustomer_Masteriid) + ctrans_type + cTrans_No TAG CDX_1
>INDEX ON STR(iCustomer_Masteriid) + ctrans_type + cTrans_No + STR(iapply_seq) + cRate_Table_Code TAG CDX_2
>
--sb--