Hi John,
you can in fact create indexes on Views although it is questionable whether it helps. In earlier versions this was only possible in Enterprise versions of SQL Server but it is now available across the board, so I read. There is no User interface to create an index, one has to use T-SQL (OK, there might be a tool out there which does this for you but the standard SSMS, SQL Server Management Studio, does not.)
If you think about what an index is and how it works, it is not easy to see how SQL Server manages to create a useful index on a View. Indeed in earlier versions it didn't and the View became "instantiated" as a hidden table with the index on this table, this had other consequences which still haunt me in the back of my mind and dissuade me from using Indexes on Views ;-) Hence the "so I read" disclaimer, for now.
Yours,
Andrew
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar