select table_name,index_name,num_rows,distinct_keys,avg_leaf_blocks_per_key,avg_data_blocks_per_key,clustering_factor from dba_indexes where owner='SAUDI6' and index_name like 'IDX_ITM_COST_MNTH%'; ITEM_COST_MONTH IDX_ITM_COST_MNTH1 57275 49271 1 1 39909 ITEM_COST_MONTH IDX_ITM_COST_MNTH2 57275 45292 1 1 41034 ITEM_COST_MONTH IDX_ITM_COST_MNTH3 57275 49271 1 1 39909 ITEM_COST_MONTH IDX_ITM_COST_MNTH4 57275 22 9 35 780
ada alasan lain kenapa si oracle keukeuh milih IDX_ITM_COST_MNTH3 ? index clustering factor nya sama aja........... --J > Kalau exec plan Anda mengakses table melalui index, > maka statistics CLUSTERING_FACTOR di index sangat > mempengaruhi COST. Semakin kecil nilainya, semakin > kecil total cost, dan semakin besar kemungkinan index > tsb dipakai. > Send instant messages to your online friends http://asia.messenger.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
