Re: 10g - Need advise on large lookup table and optimizing io

duplicate_id is null is ok in this case, as it is used in composite index.

you used user_prof_id and user_id in different two querys, are they same column?

if you are doing index only query, rebuiild the index does help if there is also dml on this table. to help improve sga efficiency.

index level =3 should be fine.

can you list a full structure of the two tables, and the SQLs? Received on Mon Jan 09 2006 - 11:34:16 CST