Originally posted by Alchemy
Has Mr. Hanky always been this way, what with wanting to shoot developers at will...?
As long as I've known him.
As far as I'm concerned, the difference is that when I joined this forum I had some dev. staff to shoot. Now there's just me: Senior Project Manager and Junior Programmer rolled into one. At least if I'm doing the shooting, I'll know when to duck
Originally posted by rajabalachandra i just want to know
what is advantage of building the index as descending?
-Raja
Yes, i was wondering that same thing. sounds like you'd be just asking to get bitten by a bug. Also, there's implications in loading the table with an ascending sequence-generated PK -- wouldn't the index splits be suboptimal?
They are treated as a special case of function-based indexes.
--------------------------------------------------------------------------------
Note:
Oracle sorts columns with the DESC keyword in descending order. Such indexes are treated as function-based indexes. Descending indexes cannot be bitmapped or reverse, and cannot be used in bitmapped optimizations. To get the pre-Oracle 8.1 release DESC behavior, remove the DESC keyword from the CREATE INDEX statement.
Originally posted by Mr.Hanky Enable true descending order indexes
They are treated as a special case of function-based indexes.
--------------------------------------------------------------------------------
Note:
Oracle sorts columns with the DESC keyword in descending order. Such indexes are treated as function-based indexes. Descending indexes cannot be bitmapped or reverse, and cannot be used in bitmapped optimizations. To get the pre-Oracle 8.1 release DESC behavior, remove the DESC keyword from the CREATE INDEX statement.
Reply With Quote
Bookmarks