-
avg_row_len and Oracle 10.1.0.2.0
Something very interesting (I hope for you too) - in 10G the avg_row_len does not depends on the position of the emply columns - I tested with table with 298 columns, then I created several copies of the table with the columns ordered by num_distinct asc/desc from user_tab_columns and after analyze the avg_row_len is the same on the original and on the copies with reordered columns.
What the ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|