Home » SQL & PL/SQL » SQL & PL/SQL » Rebuilding indexes
Rebuilding indexes [message #23084] Mon, 18 November 2002 01:14 Go to next message
Jaco
Messages: 23
Registered: August 2000
Junior Member
Hi all,
I am rebuilding indexes with a high b-level on 1 of our databases with the command " alter index indexname rebuild tablespace tablesacename;" But, after the rebuild the b-level stays the same! Any suggestions, comments...

Thnx, Jaco

P.S. I posted this Q on this forum since there is no other form that I can see that is more relevant to this Q.

Report message to a moderator

Re: Rebuilding indexes [message #23102 is a reply to message #23084] Mon, 18 November 2002 10:53 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
What is "high"? Is there anything unusual about the index in terms of selectivity, skewing, created reverse?

Report message to a moderator

Re: Rebuilding indexes [message #23116 is a reply to message #23102] Mon, 18 November 2002 23:39 Go to previous message
Jaco
Messages: 23
Registered: August 2000
Junior Member
We say a HIGH is an index with a blevel of "3", there is nothing funny about the indexes like creates reverse or so. It's just that the blevel stays at 3 after the rebuild.

Report message to a moderator

Previous Topic: to display first 5 highest paid employee
Next Topic: still connecting problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 08:56:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.