| Partitions [message #2282] |
Wed, 03 July 2002 10:23  |
la_fouine
Messages: 4
Registered: July 2002
|
Junior Member |
|
|
Hi there !
Here's my problem : I got a huge table partitionned by month in order to keep an historic of the data I store (3 years). I also have indexes and bitmap partitionned indexes (by month too) on this table.
Every month I have to add a partition in order to store new datas and therefore I have to destroy the oldest one.
To do so I use the following ALER TABLE commands : TRUNCATE PARTITION, RENAME PARTITION and SPLIT PARTITION. It seems that those commands have an impact on indexes (both kind). What is the consequence on indexes of using those commands ? Do I have to do something special everytime I add a partition ?
Is it also possible to add partition on bitmap indexes ?
Thank you for your help
la_fouine
|
|
|
|
| Re: Partitions [message #2287 is a reply to message #2282] |
Wed, 03 July 2002 11:48  |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
sir,
it is better to rebuild the index after altering the partition in the table.it will improve the performance.
k.sreenivasan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
