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 the difference between UNION and UNIONALL?

0 Answers   HCL,

---

How to get nth highest salary from employee table.

0 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---

What does truncate do?

0 Answers  

---

---

What are unicode character string data types in ms sql server?

0 Answers  

---

What does COMMIT command do?

0 Answers   Amdocs,

---

What is the need for group functions in sql?

0 Answers  

---

What are window functions in sql server?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

How do you persist objects, permissions in tempdb

1 Answers  

---