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, 1243🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...