Answer / sql2000

Lets start on what a view is, view is a name given to a
select statement. The select statement is executed when the
view name is called.

When you create index on the view the select statement is
materialized into a table and we have the contents of the
select statement as a table. This makes it faster at times
to run select statements on rather than the actual tables.
Hence it makes sense to create indexes on views.

Let me know if anyone has a better point of view on
this. :)

Answer / rama krishna

it depends on search critiria for view

what is maximum size of temp db?

4 Answers   iSoft,

---

How can we get count of the number of records in a table?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

---

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

---

How to create a user name in a database?

0 Answers  

---

Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

Difference between LEN() and DATALENGTH() in sql server ?

0 Answers   HCL,

---

What are the different index configurations a table can have?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---