Re: Performance problem: anything else I can do to make this faster?

did you gather statistics on the tables and indexes afterwards?

when you create an index, you can add the "compute statistics" clause on the end.
otherwise, exec
dbms_stats.gather_table_stats(ownname=>user,tabname=>'<table_name>,cascade=>true);

will do the job.

-bdbafh Received on Thu Mar 03 2005 - 15:50:35 CST