We are running choose base optimizer and analyze tables and indexes everyday.
A sql statement is running very very slow(more than 8 hours). The execution
plan shows that it uses hash join instead of the indexes to join 2 big
tables(full table scan on those two tables). After we delete the statistics,
it use the indexes and it runs only 20 minutes. Does anyone know how to
improve the hash join?
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Apr 07 1999 - 11:28:41 CDT
