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

What is a benefit of using an after insert trigger over using a before insert trigger?

928

---

How to modify an existing user defined function?

1028

---

Define Unique Key?

937

---

What is the difference between cartesian product and cross join?

809

---

What is a system database and what is a user database?

1023

---

What new changes are being made in SQL Server?

1092

---

What is data source in connection string?

847

---

What is page-level compression?

900

---

What is the use of @@spid?

954

---

What is query and its types?

868

---

What does it mean to be in union?

869

---

What is the purpose of indexing?

994

---

What is a bit datatype?

919

---

What is the sql case statement used for? Explain with an example?

934

---

How to list all triggers in the database with sys.triggers in ms sql server?

1009

---