Results 1 to 5 of 5

Thread: Index

  1. #1
    Join Date
    Oct 2002
    Posts
    4

    Post Unanswered: Index

    What is the difference between Cluster indexes and non cluster indexes?

  2. #2
    Join Date
    Oct 2002
    Location
    Hong Kong
    Posts
    5
    The simple answer is the leaf of clustered index is the data page in APL

  3. #3
    Join Date
    Nov 2002
    Location
    Bangalore
    Posts
    5
    To be more clear on your question:

    Clustered : Means the physical order of rows on the database device is same as the indexed order of the rows. The bottom of the clustered index contains the actual data pages. A clustered index almost always retrieves data faster than a non-clustered index. Only one clustered index is permistted per table

    Non-clustered : means there is a level of indirection between the index structure and the data itself

    Thanks,
    Aravind

  4. #4
    Join Date
    Nov 2002
    Posts
    4

    Smile Re: Index

    Originally posted by hkrishna
    What is the difference between Cluster indexes and non cluster indexes?
    You can have only Physical order of data that is why you can have only one Clustered and many non-Clustered Indexes

    Cheers,
    Kenny

  5. #5
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Be carefull : your answers are correct regarding the APL schema. It's not so easy with the tables using the DOL pages

Posting Permissions

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