Re: Index Usage ?!

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Fri, 25 Jul 2003 11:57:12 +0900
Message-Id: <26007.339499@fatcity.com>

Thanx Breitling.

<quote>Leave the index un-analyzed if it works for you</quote>

as u said,index IDX_PROFILE_SHINKI is not analyzed now. that works fine.

but there are seperate indexes on column PREF, FLAG and SEX. when those indexes are used ,cost=999.

whereas when IDX_PROFILE_SHINKI ( a composite index on ENTPC, FLAG,SEX,PREF,ENTDAY) is used , cost=7.

1.whys there is a huge difference in COST ? 2.does it mean that a composite index is better than individual ones ?

Kindly throw some light on this.

Regards, Received on Thu Jul 24 2003 - 21:57:12 CDT