Collections:
Creating an Index on a View in SQL Server
How To Create an Index on a View in SQL Server?
✍: FYIcenter.com
If you need to search and sort data in a view with a large number of row, you may want to create an index on the view to speed up your search process.
The tutorial exercise below shows you how to create a unique clustered index on a view.
DROP VIEW fyi_links_view; GO CREATE VIEW fyi_links_view (ID, UrlReversed) AS SELECT id, REVERSE(url) FROM fyi_links_copy WHERE counts > 1000; GO CREATE UNIQUE CLUSTERED INDEX date_string ON fyi_links_view (ID); GO Cannot create index on view 'fyi_links_view' because the view is not schema bound. ALTER VIEW fyi_links_view (ID, UrlReversed) WITH SCHEMABINDING AS SELECT id, REVERSE(url) FROM dbo.fyi_links_copy WHERE counts > 1000; GO CREATE UNIQUE CLUSTERED INDEX date_string ON fyi_links_view (ID); GO EXEC SP_HELP fyi_links_view; GO index_name index_description index_keys ----------- ------------------------------------ ---------- date_string clustered, unique located on PRIMARY ID
⇒ Using INSERT, UPDATE and DELETE Statements in SQL Server
⇐ SCHEMABINDING - Binding Views to Underlying Tables in SQL Server
2016-11-03, 1328🔥, 0💬
Popular Posts:
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...