Index as hot block
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 May 2010 11:08:52 +0000 (GMT)
Hi
I have a partitioned table called mytable (a,b,c,d,e,f) partitioned by range on
column a.
I need to enforce a unique constraint
currently the uniqueness is enforced by creating a locally partitioned index on
myindx(c,b,a)
and this has become a hot block.
I was thinking of rebuilding that index and using myindx(a,b,c)
can you guys let me know what your thoughts are ?
regards
Other related posts:
