| mou |
Posted: Feb 27, 2007 04:26:38 PM |
Total Post: 6
Joined: Feb, 2007
|
hello vigyan, i am new to dbapool.
i have two questions:
1. what happened to the index associated with a table, when the table is moved to a different tablespace using alter table... move command?
2.is coalesceing is possible only on b-tree index or it can also be applied on bit mapped index? if yes then how?
mousumi. |
|
|
 Vigyan |
| Posted: Feb 27, 2007 11:22:33 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Hi Mousumi,
1. When you use "ALTER TABLE MOVE TABLESPACE", it only move the table into new tablespace but not the associated index. You will have to manually rebuild index in the new tablespace.
2. Yes, you can COALESCE a bitmap index. This is done in the same way as you do for btree index.
e.g.
ALTER INDEX index_name COALESCE;
Remember, you cannot move index to another tablespace using Coalesce. I personally preferred rebuilding index.
Hope it helps.
Vigyan
|
|
|
|
|
| Jayanta |
| Posted: Feb 28, 2007 04:06:35 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
hello mousumi,
coalesce rebuilds only the index blocks, where as rebuild shrinks the height of the index(if applicabe) and also removes the intra block fragmentation plus allows u to move the index to a different tablespace
thanks
|
|
|
|
|
| Raj |
| Posted: May 11, 2007 02:18:09 AM | |
|
Total Post: 9
Joined: Apr, 2007
|
Hi
When you move table to another TS index will become unusable and you need to e\rebuild them
|
|
|
|
|
| Jayanta |
| Posted: May 12, 2007 02:59:25 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
after moving tables the row ids of that table changes.thats the root cause
that u need to rebuild indexes.
cheers!
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
