DESC in primary key - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: DESC in primary key

  1. #11
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    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

  2. #12
    Join Date
    Jan 2001
    Posts
    3,131

    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.

  3. #13
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #14
    Join Date
    Jan 2001
    Posts
    3,131
    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.

  5. #15
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #16
    Join Date
    Jan 2001
    Posts
    3,131
    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
  •  


Click Here to Expand Forum to Full Width