Suresh B. (10/10/2012)
sunny.tjk (10/10/2012)
So, can I create separate NC indexes on OFFR_TYPE_CD and CRETD_DT columnsNo. Single composite index is better.
also can I create a composite index on [LKUP_ID] and [ATTR_VAL] columns?
Yes.
If i create a single composite index on [LKUP_ID] and [ATTR_VAL] columns, will the index be useful if I run a query like this:
SELECT LKUP_ID, ATTR_VAL
FROM [APP_DEAL]
WHERE ATTR_VAL=97067
My question is, will the index be useful only if I use both LKUP_ID and ATTR_VAL in the WHERE clause or can I use either one of these columns in the WHERE clause.