32.SQL Server Indexed Views /Materialized views
Basically, all you need to do is:
create a regular view
create a clustered index on that view
and you're done!
-- Indexed view/ Materialized view in sql server
-- while we create indexed view WITH SCHEMABINDING hint should be present
-- we cant use EXISTS/NOT EXISTS , JOINS , COUNT(*), min,maX, SUB QUERIES AND TABLE HINTS AND union
-- text,ntext,image
-- top also we cant use in Indexed views
-- COUNT_BIG(*) IS MANDATORY WHEN YOU PERFORM AGGREGATIONS
-- MATERILIZED/indexed VIEW STORED DATA IN PHYSICALLY
-- https://learn.microsoft.com/en-us/sql...
--:syntax for Indexed View :
--CREATE VIEW VIEW_NAME
--WITH SCHEMABIDING
--AS
--SELECT COL1,COL2
--FROM TAB1
--CREATE UNIQUE CLUSTERED INDEX INDEX_NAME ON VIEW_NAME (COL1,CLO2)
#sql #sqlserver #database #dataanalytics #dbms #views #sql #tech2bi