yahoo.... i got it right..

I have created a heap table and inserted data 50,00,000 records and then deleted

Observed the below points

1. page count is reduced before and after the rebuild statement , that implies tables is compressed and rebuilt

2. but found fragmentation is increased.

It took some time to select 4 :w00t:

finally, I did it right