Re: advice required on partioning

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <jdunn@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 26 Jan 2005 09:20:31 -0500

I had to do something simlar. I opted for a global non-partitioned index on
the field users query. I get 1 hr of downtime per night to archive/drop the
oldest partition and rebuild the index. I need to rebuild the index because
it's global  and therfore gets invalidated by the drop. Queries were too
slow making the index local. But on another database all our indexes are
local bitmap on the partitioned tables and the queries fly. So, moral of the
story, you have to test.


Other related posts: