Re: 10g CBO and how to determine cardinality on INDEX_FFS?

Sure.
 I don't want to give you the current stats because we have jobs that re-generate stats so if the table
 data has changed, the stats will be different, but the structure of the table is pretty simple.

 LINK_ 427037565

 USER_PROF_ID       NUMBER NOT NULL
 PRODUCT_ID           NUMBER NOT NULL,
 AFFILIATE_ID           NUMBER NOT NULL,
 DATE_SUB               DATE,
 DATE_CONF            DATE,
 CONFIM                    VARCHAR2(1),
 RCODE                    VARCHAR2(21)         -- this is almost always

  3 indexes on the table.
 LINK_427037565_PUC_U - unique on (PRODUCT_ID,USER_PROF_ID,CONFIM) compress 1
 LINK_427037565_UP_U - unique on (USER_PROF_ID,PRODUCT_ID)  LINK_427037565_D - non-unique on (DATE_CONF DESC)

Some Sample Data - all columns concatenated by '|'

302817134|430657811|427037568|10/17/05 17:56|10/17/05 17:56|0|
317909533|430657811|427037568|11/06/05 11:11|11/06/05 11:11|0|
430672053|430657811|427037568|10/17/05 17:56|10/17/05 17:56|0|
194057776|430657811|427037568|11/06/05 11:11|11/06/05 11:11|0|
256408509|430657811|427037568|10/17/05 17:56|10/17/05 17:56|0|
247974322|438075481|427037568|11/06/05 11:11|11/06/05 11:11|0|
439599713|430657811|427037568|11/06/05 11:11|11/06/05 11:11|0|
263760465|430657811|427037568|10/17/05 17:56|10/17/05 17:56|0|
430672059|430657811|427037568|10/17/05 17:56|10/17/05 17:56|0|
430672060|430657811|427037568|10/17/05 17:56|10/17/05 17:56|0|

--peter Received on Fri Nov 18 2005 - 08:28:21 CST