Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    46

    Unanswered: Question on Indexes

    I know what a Clustered index and a non-clustered index is. I also know what the difference between a b-tree and a bit mapped index is. Could someone please tell me what the difference between a non-clustered index is with a bitmap index? Similarly, what is the difference between a clustered index and a b-tree index?

    It seems that SQL Server books talk in terms of clustered and non -clustered indexes. Oracle books talk in terms of b-tree and bit map indexes.
    One other thought and Oracle does support non-clustered and clustered indexes as I have used them recently.

    Could someone please help?

  2. #2
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    No, Oracle does not have clustered indexes. The equivalent might be index-organized tables.

  3. #3
    Join Date
    Feb 2006
    Posts
    46

    Indexes again

    OK, you may be right in that Oracle does not support clustered indexes.
    But if used the following statement, what kind of index is this?

    Create index indSearchDate on Trans(tdate) ;

  4. #4
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    That would be a btree index.

    I'm not sure "Oracle does not support clustered indexes" is quite fair. From what I've read, I think index-organized tables and single table hash clusters are pretty close.

Posting Permissions

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