Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    10

    Unanswered: To create nonclustered index or its equivalent in oracle

    Hi,

    Actually i able to create a nonclustered index in SQL Server 2005, but unable to create nonclustered index in oracle, does any one know how to create nonclustered index or its equivalent in oracle.

    Warm Regards,
    Mushq

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Hi,

    first I had to find SQL Server Data Structure article about index types in SQL server (as I do not know it at all). Based on this:

    - non-clustered index corresponds (in the storage point of view) to normal Oracle b-tree index creatable by CREATE INDEX statement

    - clustered index corresponds (again only regarding its storage) to INDEX ORGANIZED TABLE (as mentioned in the upper article)

    where did you find basis for your claim (which is in contradiction with mine)?

    however I would not blindly map Oracle indexes to SQL Server ones using this 'conversion method', read on AskTom migrate sql server clustered index (and the following posts).

Posting Permissions

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