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 to name query output columns in ms sql server?

1 Answers  

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

1 Answers  

---

How do I find query history in sql server?

0 Answers  

---

What is stored procedure in SQL..??

2 Answers  

---

Do you know what are pages and extents? : SQL Server Architecture

1 Answers  

---

What the difference between UNION and UNIONALL?

1 Answers   HCL,

---

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1 Answers  

---

Explain Capacity planning to create a database? and how to monitor it?

1 Answers  

---

What is the difference between a check constraint and a rule?

1 Answers  

---

Tell me extended events in sql server 2008?

1 Answers  

---

Explain user defined views?

1 Answers  

---