Answer / 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

Answer / manoj joshi

Creating index on views is not possible in Sybase.

Which sql server is best?

0 Answers  

---

What is rtm version in sql server?

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

What are different types of constraints?

0 Answers  

---

Explain the different index configurations a table can have?

0 Answers  

---

Tell me can we use custom code in ssrs?

0 Answers  

---

What does select 1 mean?

0 Answers  

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

What is a with(nolock)?

0 Answers  

---