Hello,

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