Index Creation Question - Which is More Efficient?

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 29 Jul 2006 00:25:29 GMT
Message-ID: <ZVxyg.13210$2v.2577@newssvr25.news.prodigy.net>

I'm trying to rewrite some existing code and keep coming across indexes being created similar to this:

CREATE INDEX TSYSCONTYPRES_I
ON T_HB_UPDATE_RESULTS(PERSON_ID||TRIM(TYPE)||"DATE"); Other than the fact there are reserved words in the code would that index be efficient or would one defined like before (using the same fields just for comparison purposes) be more efficient:

CREATE INDEX TSYSCONTYPRES_I

         ON T_HB_UPDATE_RESULTS(PERSON_ID,
                                                              TYPE,
                                                              "DATE");

Thanks. Received on Fri Jul 28 2006 - 19:25:29 CDT