| After Table analyze, the number of blocks goes Down [message #619767] |
Thu, 24 July 2014 23:35  |
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
|
Member |
|
|
Hello,
When I moved the TABLE to another tablespace then I rebuild all the respective indexes and gathered statistics for the table,
the number of BLOCKS reduced.
So, can anyone please help me why the number of BLOCKS reduced?
Many thanks in advance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: After Table analyze, the number of blocks goes Down [message #619806 is a reply to message #619767] |
Fri, 25 July 2014 02:19  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
hitesh.bhatt wrote on Fri, 25 July 2014 05:35Hello,
When I moved the TABLE to another tablespace then I rebuild all the respective indexes and gathered statistics for the table,
the number of BLOCKS reduced.
So, can anyone please help me why the number of BLOCKS reduced?
Many thanks in advance.
Think of it like this: the table is not atually moved. The underlying implementation is that a new table is created, all the rows inserted into it, the original table is dropped, and the new table renamed. You can see all this happening if you query appropriate views while the move is progress. Following the insert all the block of the new table will be fully populated, whereas the original table might have had some space emptied by deletions.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
