Sunday 22 April 2012

Problem with Forwarding Pointers ?



Forwarding pointers in heap is a bad thing for database in terms of performance.

For an analogy you are trying to insert a row in a table and the data is not fit to the same page, it takes next page to store the data. But the forwarding pointers are set to the previous page, so the non clustered index is not updated properly.
 If have you so many forwarding pointers the performance is going to decreased as non clustered index is not properly used.
So what we do to solve this problem.
SQL server 2008 has the solutions.
Use
ALTER TABLE <Tablename> REBUILD
It just removes the forwarding pointers and rebuilds all the indexes related to table.
Posted by: MR. JOYDEEP DAS

No comments:

Post a Comment