Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sruthi
Index created on view is called as indexed view or
materialised view.
To create index on a view we should create a view
with "schemabinding"
eg:
create view v1 with schemabinding as
select empno,ename from dbo.emp
---
while creating view with schema binding refer to table by
default owner
---
now create index on that view
--
create clustered index i1 on v1(empno)
--
now this is called as indexed view
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How many replicas are maintained for each sql azure db?
How to find the login name linked to a given user name?
What is normalization process?
What is the maximum size of column in sql server?
List the different normalization forms?
What is a trigger and types of a trigger?
What is a field name?
Do you know what guidelines should be followed to help minimize deadlocks?
How to enforce security in sql server? : sql server security
What happens to a trigger with multiple affected rows?
How do I manually uninstall an instance of sql server 2016?
what is datawarehouse?
What is the default server name for sql server?
How to generate create table script on an existing table in ms sql server?
Explain SSRS Architecture?
