Thanks, Andrew.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 9, 2014, at 5:24 PM, yahoo@craven.de wrote:
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 (10) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar