Re:Index Usage ?!

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Fri, 25 Jul 2003 18:42:32 +0900
Message-Id: <26013.339583@fatcity.com>

Irfan,

as u said,yes the data in SEX,FLAG,PREF columns are skewed.

do i need to create histograms for the COLUMNS or INDEXES ?

The COST of using IDX_PROFILE_SHINKI (composite index - not analyzed ) is 7 & The COST of using individual indexes (on SEX,FLAG,PREF - analyzed ) is 999 now.

will using histograms reduce the COST inspite of using individual indexes ?

Regards,
Jp.

>From: Irfan Khan <irfan.khan_at_converge.com>
>To: "'Prem Khanna J'" <jprem_at_kssnet.co.jp>
>
>In this case i will give u only one statement, Ur data is very highly
>skewed, Play with histograms.
>
>Irfan , Khan
Received on Fri Jul 25 2003 - 04:42:32 CDT