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 the critical issues you have resloved in your company

0 Answers   Wipro,

---

How many categories of functions based their return modes?

0 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

Explain triggers in sql?

0 Answers  

---

What are transactions in sql?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

What is a group function explain with an example?

0 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

What is a primary index?

0 Answers  

---

What are the new features in sql server 2016?

0 Answers  

---