October 8, 2002 at 9:54 am
I have 2 tables in one DB. Table2 is created from Table1, has fewer columns and rows than table1 and I ran few queries that I got from this board to see table size and Table2 is taking more space than table1. Even when we exclude index space, dataspace for T2 is bigger than T1. Does anyone have any ideas?
Thanks.
October 8, 2002 at 10:40 am
Have you checked fragementation? Could be using more extents.
Steve Jones
October 8, 2002 at 1:01 pm
Are we making the assumption that the field types are the same? And the fill factor....
October 8, 2002 at 2:10 pm
Actually I made the same assumption but numeric field in both tables had different length. And that was the reason size was different.
Thanks both of you.
October 8, 2002 at 3:33 pm
Thanks for the update.
Steve Jones
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply