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.

How is foreign key related to primary key?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is repeatable read?

0 Answers  

---

What are the dmvs? : sql server database administration

0 Answers  

---

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

What is table level trigger?

0 Answers  

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

what are batch in sql server?

2 Answers   Satyam,

---

Can coalesce return null?

0 Answers  

---

What is the order by used for?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---