Clustered Index..


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Clustered Index..

  1. #1
    Madhu Guest

    Clustered Index..


    Hi all,

    I would like to have some one's help on Clustered Index.
    Why there is only one clustered Index on a table?????


    Thanks in advance.

    Madhu.

  2. #2
    Daniel Reber Guest

    Re: Clustered Index..

    The data in the table is sorted by the clustered index. The data can only
    be sorted in one way.

    Daniel Reber
    Datamasters, Inc

    "Madhu" <Gundapaneni@lycos.com> wrote in message
    news:3de4dedb$1@tnews.web.devx.com...
    >
    > Hi all,
    >
    > I would like to have some one's help on Clustered Index.
    > Why there is only one clustered Index on a table?????
    >
    >
    > Thanks in advance.
    >
    > Madhu.




  3. #3
    David Satz Guest

    Re: Clustered Index..

    check out this tip:
    http://www.sql-server-performance.co...ed_indexes.asp
    HTH,
    Dave
    "Madhu" <Gundapaneni@lycos.com> wrote in message
    news:3de4dedb$1@tnews.web.devx.com...
    >
    > Hi all,
    >
    > I would like to have some one's help on Clustered Index.
    > Why there is only one clustered Index on a table?????
    >
    >
    > Thanks in advance.
    >
    > Madhu.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center