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 do you delete a trigger?

0 Answers  

---

Explain logical operators in sql server?

0 Answers  

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

what happens on checkpoint? : Sql server database administration

0 Answers  

---

what is index seek and index scan?

2 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

How many types of triggers in sql server?

0 Answers  

---

How to use go command in "sqlcmd"?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

How many cores do I need for sql server 2016?

0 Answers  

---

What is a system database and what is a user database?

0 Answers  

---