While investigating index splits, I encountered a fairly 'mind-numbing' number. But first, here's the basic set up on a database with default page size 4K:
CREATE TABLE LONGT (V1 CHAR(254)) ;
CREATE INDEX IDX_LT ON LONGT ( V1);
And populate this table with 50,000 rows of ascending 'numbers', starting with 1.
Guess what BLEVEL you get?
Drumroll please ... it is ... 5!
I'm beginning to wonder if this BLEVEL has the same meaning as the BLEVEL I have been exposed to ... ;)
