Home Forums SQL Server 2019 SQL Server 2019 - Administration When to use a clustered and/or non-clustered index RE: When to use a clustered and/or non-clustered index

  • August 3, 2017 at 9:45 am

    #1953999

    itmasterw 60042 - Thursday, August 3, 2017 9:23 AM

    Hi,

    I have been looking all over the net and in books to findwhen to use a clustered and/or non-clustered index; and all I get isdefinitions, not when to use one or both. Can you please tell me how I canlearn this, or would you be able to give me some general steps to do this?

    Thank you

    The stairways article series right here on this site is absolutely fantastic. http://www.sqlservercentral.com/stairway/72399/
    Once you fully understand indexes it becomes second nature if a given index should be clustered or nonclustered.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/