• Not what I asked.

    Is the table bigger than the view?

    There's more going on when you index a view than indexing a table, the query that defines the view has to be run to get the data, then the index has to be created, so if the view's inefficient then the creation of the index will take a long time.

    Indexing the table however just requires reading the table and then creating the index

    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