-
Re: Shooting Develinterlopers
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
-
Re: Shooting Develinterlopers
Originally posted by Alchemy
Has Mr. Hanky always been this way, what with wanting to shoot developers at will...?
Rick
Actually years of therapy have improved my disposition, I used to be angry.
MH
I remember when this place was cool.
-
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?
-
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.
--------------------------------------------------------------------------------
http://download-west.oracle.com/docs...ndexes.htm#430
MH
I remember when this place was cool.
-
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.
--------------------------------------------------------------------------------
http://download-west.oracle.com/docs...ndexes.htm#430
MH
Ypu, that's a descendingindexalright.
But what would be the advantage for JDF in using one of these over a regular index?
-
Well, at the very least, you would be different.
We can call it the non-conformists index if you like.
MH
I remember when this place was cool.
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
|