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 can we write or define DDL statements in Sql server and DML statements?

3 Answers  

---

wht's the differece between sqlserver05 and sqlserver2000

3 Answers  

---

How to retrieve field values using mssql_result()?

0 Answers  

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---

What are “lock” hints?

0 Answers  

---

What is a sql join?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

---

What is policy management?

0 Answers  

---

What it means to be triggered?

0 Answers  

---

How to update existing rows in a table?

1 Answers  

---

Can we update data in a view?

0 Answers  

---