criteria to use iindex

  • hi,

    can i create two indexes on a same table?what is clustered index and what is non clustered index

    please can any one reply me

  • Hello Karthikeyan,

    These forums are here to help those who work with SQLS and encounter some problem with which they need assistance. Your questions show that you don't know anything about SQL Server (and likely not much about databases at all), so I don't think it would help to give you answers which you would understand only marginally.

    I think you should read these things in BOL (Books Online = SQL Server Help) and visit some basic course of SQL or about databases in general.

  • I'm with Vladan on this one.  This topic has spawned a few 100 articles on the web because the topic is so large.  Here are 2 articles that will get you started understanding indexes :

    http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp

    http://www.sqlservercentral.com/columnists/rgummadi/indexingstrategies.asp

  • hi Ninja's_RGR'us thanks a lot for kind reply

  • No problem.  We all started somewhere and even after 3 years I'm still learning something new every so often.  Don't get discouraged if you don't see the end of it anytime soon.  That topic is more of an art than a science.

Viewing 5 posts - 1 through 5 (of 5 total)

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