Server in a previous version of SQL Server, the view is not indexed, so the view is generally useless, in addition to occasionally use it to do some authority management to
Outside Querying a view and using a connection statement is no different in execution efficiency.
However, in the new century, Microsoft has brought some changes (including its own), in which you can create indexes on views in SQL Server 2000. This
, existing applications can be made much more efficient by not modifying them. Generally in programming we will use some complex connection, so must be in the connection of two
End plus index to achieve better efficiency, and the results of the connection to the sorting or grouping is also very slow, now everything is different, the program will no longer appear complex
SQL statements, all operations are done with custom functions, storage structures, and views, and we just need to write a select * from table in the program.
Other things are handled by the database administrator. Say a bunch of nonsense, in the end how to build an index on the view? Stupid! Would you add an index to a table? Change the name of the table to the view name, what? Don't use T-SQL Gazzo
Cited? are used by Access and SQL 7. Index or modify the index, the Grid pane above the right button manage indexes on the line, and then I will not ignore.
Insist on doing one thing every day is really difficult ah, yesterday was lazy: p, but yesterday in the XML version of the irrigation, at least do some things do it ^.^
