Post reply

Clustered Index space concern.

  • August 7, 2009 at 4:24 am

    #137121

    Hello SQL Experts

    Could you please clarify my concern?

    Let me explain the scenario..

    Indexes are defined on both tables and views.

    Clustered or Non-Clustered Indexes can be defined on the tables or views. Now, Clustered indexes defined on tables are physical and consumes space but Indexes defined on views also will consume any space or this too is virtual?

    Regards

    Sourav

    Thanks.

  • August 7, 2009 at 4:49 am

    #1035885

    If you put a clustered index on a view, the view is materialised and stored almost as if it was a table.

    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

  • August 7, 2009 at 5:07 am

    #1035891

    Thanks Gail for your response.

    Infact, I can repro the issue in my local system to see the outcome but thought to get a response from our SQL Experts if this is very known.

    Regards

    Sourav

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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