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.

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

---

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

What do u mean by orphan users, how will u list them in the DB

2 Answers   IBM,

---

What are the triggers in sql?

0 Answers  

---

Mention the different authentication modes in sql server.

0 Answers  

---

What is a scheduled job or what is a scheduled task?

0 Answers  

---

What is a job?

3 Answers  

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

what is Archive old data?

1 Answers  

---

What is index in an assignment?

0 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

Why should we go for stored procedures? Why not direct queries?

0 Answers  

---