Home Grown Partitioning

To ORACLE-L tuning Gurus:

Running Oracle 8.1.7.0.2 on W2K

I have a query involving a partition view, but I can't seem to get it to filter partitions. Even though I join it to a table with rows that join only to one of the view's underlying tables, it persists in performing the union-all and then hash-joining the result. But this is very inefficient; when I join the query to the single underlying table, it runs ten times faster.

Other queries using this partition view properly filter partitions, but for some reason, we have a query which is refusing to behave.   

I have tried the USE_NL hint (to prevent the hash-join) and the INDEX hint, but neither have worked.

We have
partition_view_enabled = TRUE in the ini file.

Any Suggestions Would be greatly appreciated. (We can't run Oracle Enterprise Edition
and therefore can not use Oracle Partitioning)

Thanks, and
Sorry for the long post

(I didn't include the query because it make this post even
longer, if anyone would like to see it I will email it offline)

Scott Crabtree

Professional Software Systems

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Crabtree
  INET: scott_at_psscorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).