use dbms_stats ofcourse do collect histograms, atleast on indexed columns.
funky... "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail." "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Forum Rules
Reply With Quote