Professional Web Applications Themes

Quick Question on Indexing - Microsoft SQL / MS SQL Server

Can you have more than one clustered index on a table? If so how can I set it up?...

  1. #1

    Default Quick Question on Indexing

    Can you have more than one clustered index on a table? If
    so how can I set it up?
    Samuel Guest

  2. #2

    Default Re: Quick Question on Indexing

    You can not. You can have a composite clustered index across multiple
    columns but be careful in this use as it can create weird page split
    problems and also bloat your non-clustered indexes as the NCI's use the
    clustered index key as the row locator. Just curious, why are you wanting to
    use multiple clustered indexes?

    --
    Ray Higdon MCSE, MCDBA, CCNA
    --
    "Samuel Perkins" <com> wrote in message
    news:10ea01c3626f$d12ac980$gbl... 


    Ray Guest

  3. #3

    Default Re: Quick Question on Indexing

    You cannot have > 1 clustered index on a table.

    --
    Tom

    ---------------------------------------------------------------
    Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    SQL Server MVP
    Columnist, SQL Server Professional
    Toronto, ON Canada
    www.pinnaclepublishing.com/sql


    "Samuel Perkins" <com> wrote in message news:10ea01c3626f$d12ac980$gbl...
    Can you have more than one clustered index on a table? If
    so how can I set it up?

    Tom Guest

Similar Threads

  1. Quick CSS question
    By David in forum HTML & CSS
    Replies: 13
    Last Post: October 22nd, 04:33 PM
  2. Indexing question...
    By Davedb@adobeforums.com in forum Adobe Indesign Windows
    Replies: 8
    Last Post: July 13th, 08:12 PM
  3. One quick Question!
    By Tiankhy in forum Macromedia Flash Sitedesign
    Replies: 2
    Last Post: June 15th, 08:03 AM
  4. Quick IB question
    By John in forum Mac Programming
    Replies: 6
    Last Post: January 25th, 02:36 AM
  5. Quick indexing question
    By Stephen M. Wallace in forum FileMaker
    Replies: 3
    Last Post: September 3rd, 09:09 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139