create index to table RSS

• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  create index to table

  Mar 02, 2012 08:28 AM|LINK

  how to create a cluster index ? is it faster when i update table joining with the table (with index) ?

  and how to define a col that inclued index? when i define a index include 2 or more column

• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: create index to table

  Mar 02, 2012 08:40 AM|LINK

  Visit

  http://www.codeproject.com/Articles/59093/Defining-Indexes-with-SQL-Server-2005

  http://technet.microsoft.com/en-us/library/cc917715.aspx

  Yogesh Bhadauriya
  .Net All About
  
  • Edited by yrb.yogi on Mar 02, 2012 08:40 AM
  • Marked as answer by Chen Yu - MSFT on Mar 12, 2012 10:22 AM
• • Reply
  

  Chen Yu - MS...

  All-Star

  21569 Points

  2493 Posts

  Microsoft

  Re: create index to table

  Mar 07, 2012 06:56 AM|LINK

  -_-

  how to create a cluster index ?

  Hi,

  you could also reference on blow link, it will provide you syntax and some requirement when you create a cluster index.

  Please see: http://msdn.microsoft.com/en-us/library/ms188783.aspx

  Thanks.

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Chen Yu - MSFT on Mar 12, 2012 10:22 AM
• • Reply
  

  vijayano

  Member

  162 Points

  51 Posts

  Re: create index to table

  Mar 07, 2012 07:16 AM|LINK

  Hello,

  To creata an index refer the links below.

  http://msdn.microsoft.com/en-us/library/ms188783.aspx

  http://technet.microsoft.com/en-us/library/ms345331.aspx

  http://www.codeproject.com/Articles/39006/Overview-of-SQL-Server-2005-2008-Table-Indexing-Pa