Post reply

doubt

  • October 24, 2006 at 1:39 am

    #170130

    hi

    i use sqlserver as a backend tool for storing my tables in the database.i want to apply clustering indexes to boost the performance of server to retrieve the records.doest sqlserver supports clustering if so could  anybody please suggest me how?

                               

  • October 24, 2006 at 3:07 am

    #667507

    Hi,

    have a look on the artical

    http://www.sqlservercentral.com/columnists/gvijayakumar/executionplans.asp

    This will clarify you how SQL Server used cluster/non cluster Index.

     

    Hope this will slove you problem.

    Thanks

    cheers

  • October 24, 2006 at 8:00 pm

    #667751

    Choose wisely and carefully... you get one clustered index per table.  And, just because you have a clustered index on a table does not guarantee it will be used... you have to write the right kind of SQL. 

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply