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, 3053🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAG...
Where to find answers to frequently asked questions in general areas of Microsoft SQL Server Transac...