Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    12

    Unanswered: Indexing Oracle 9i vs. SQL Server 2000.

    Hello folks.

    Im new in Oracle, Id like to know some stuff about indexes in Oracle 9i.

    What are the differences between Oracle 9is index and SQL Server 2000s indexes. I know the Clustered, Nonclustered and Full-Text in SQLSVR, but Oracle i dont know.

    Could you help me?


    Cheers,
    Hidd
    Rafael Hidd Germenink
    DBA - Database Administrator
    ICS - Impacta Certified Specialist

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Check out

    http://download-west.oracle.com/docs....htm#sthref883

    For information on indexes.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    May 2004
    Location
    Germany
    Posts
    25
    Hi,
    there is no difference between SQl Server and Oracle indexes in concept. A clusterd index is called a index organized table in oracle terms.
    Nonclusterd indexes are normal B-Tree Indexes.
    Look at:
    http://download-west.oracle.com/docs...chem.htm#23878

  4. #4
    Join Date
    Dec 2003
    Posts
    1,074
    Clustered indexing in Sybase/SQL Server was meant to allow faster querying for 'range' queries, "where data_modified between '1/1/04' and '1/31/04' ". That way, because adjacent rows on the same data blocks were retrieved, the query would be faster.

    The doc listed above made several comments about using the Key field as the column to create the Oracle Index-Organized table around.

    Sybase recommends against this, as the Key field is normally not present in a range query ("where ssn between '123-45-6789' and '555-55-5555' "), and so you gain no real benefit in performance.

    Is the same true for Oracle?

    -Chuck

Posting Permissions

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