Home Forums SQL Server 2005 Administering clustered index RE: clustered index

  • April 16, 2008 at 5:37 am

    #803002

    chandrachurhghosh (4/16/2008)

    we cannot have any non-clustered index if we don't have a clustered index on a table

    That's not the case. There's no requirement in SQL server for a table to have a clustered index. Nonclustered indexes can be created on a heap just as they can on a cluster.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass