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