Re: Indexing partition key
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: ax.mount@xxxxxxxxx, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 12 Sep 2010 00:04:27 +0800
I presume that 9 hours data is 9 partitions. That should also mean
that your query predicates DO specify Hours (and minutes,seconds ?).
Is the Index a GLOBAL Index ?
Hemant K Chitale
http://hemantoracledba.blogspot.com
At 12:52 AM Saturday, amonte wrote:
Hi all
I have a data warehouse running in 11.1.0.7.
There is a fact tables with 3000 million of rows range partitioned
at entered_date per hour, entered_date is also indexed (btree
index). This is giving some performance headaches because many
queries are so simple as
<snip>
The range can go from 1 hour to 7 days. The problem is that instead
of scanning partitions (full scans) it uses index range scan and to
check 9 hour data instead of taking around 20 seconds (using
no_index hint) it takes 2 hours.
--
http://www.freelists.org/webpage/oracle-l
Other related posts: