mac.unsw_at_gmail.com wrote:
> Hi: everybody
>
> just say hello to you guys. of course I need some help from your
> suggesstion, I am a oracle DB developer, recently join a project, one
> query I am currently working with is to join 9 tables together, the
> largest fact table have around 27 million records, and other tables
> have no more than 1000 records, all the join are equal joins and join
> criteria are indexed, the query was designed to perform the most
> restricted selection first, more indexs are added to speed up the
> searching process.
Oracle version?
Are statistics current with DBMS_STATS?
Where is your EXPLAIN PLAN or AUTOTRACE?
etc. etc. etc.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Nov 21 2005 - 09:46:02 CST
