Views and Indexes The basic tables of a database are designed according to the viewpoints of database designers and may not necessarily meet the needs of users. SQL Server can define new tables according to user application requirements. Such new user-oriented tables are called views. Views are virtual tables with restrictions on their update operations. In order to quickly find the required data from a huge database, SQL Server 2005 provides indexing technology similar to the table of contents of a book. Proper use of indexing technology can achieve good query performance. This chapter mainly introduces the creation and use of views in the SQL Server 2005 database system, index types, and the creation and use of indexes. The content includes: view overview, view creation and use, view definition information review, view modification, understanding and index creation, index modification and index information viewing, index deletion, full-text indexing and full-text search, etc.
You Might Like
Recommended ContentMore
Open source project More
Popular Components
Searched by Users
Just Take a LookMore
Trending Downloads
Trending ArticlesMore