-
I have a big table (7 million rows) and the blevel is 3 after I did analyze index index_name compute statistics; I then rebuilt the index by alter index index_name rebuild; When I analyzed again and checked teh blevel from user_indexes, it is still the same, 3. Why is the number not coming down? Does this have something to do with the large size of the table? If so, would the rule of thumb that blevel should be less than 4 still hold true for huge tables?
J.T.
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
|