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 page splits?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

What is a database table?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

---

Explain the third normal form(3nf)?

0 Answers  

---

How do you rename a table in sql server?

0 Answers  

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

What are the methods used to protect against sql injection attack?

0 Answers  

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What is acid db?

0 Answers  

---