Results 1 to 6 of 6

Thread: Indexes

  1. #1
    Join Date
    Apr 2004
    Posts
    113

    Unanswered: Indexes

    We have a Sybase database that is ASE. We create clustered indexes with the IGNORE_DUP_ROW option. What is the name for this type of index in oracle?

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    B*Tree clustered index with compress option??

    Maybe just B*Tree index using compress
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Apr 2004
    Posts
    113
    Can I use B*Tree for th Allow_Dup_Option in Sybase also?

  4. #4
    Join Date
    May 2004
    Location
    Germany
    Posts
    25
    It is same time ago, that i used Sybase. In my mind a Sybase clusterd index is called a "Index-Organized table" in Oracle terms.

    Have a closer look a the documentation:
    http://download-west.oracle.com/docs...chem.htm#23878

  5. #5
    Join Date
    Mar 2004
    Location
    Colorado
    Posts
    49
    In Sybase (and SQLServer) a clustered index will save the row data in order such that the first row of the table is physically first. This is why do do not want to change a key value very often in these database. Oracle has no simular support for this.

  6. #6
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89
    Quote Originally Posted by borzoi313
    In Sybase (and SQLServer) a clustered index will save the row data in order such that the first row of the table is physically first. This is why do do not want to change a key value very often in these database. Oracle has no simular support for this.
    Cluster index concept in Oracle is very different. You can take it as columns of 2 or more tables having similar datatypes and are related, then they can be stored at a common physical location. Since it is read from same disk area, the retrieval is faster incase of the tables are joined.
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •