Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead?

Question Posted / priyanka

Answers were Sorted based on User's Feedback



If there exist a index on the table, and we then make a view on that table (include the indexed co..

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. :)

Is This Answer Correct ?    0 Yes 0 No

If there exist a index on the table, and we then make a view on that table (include the indexed co..

Answer / rama krishna

it depends on search critiria for view

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is the difference between value type and reference type?

0 Answers  

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

How to execute function in stored procedure sql server?

0 Answers  

What is difference between table aliases and column aliases? Do they affect performance?

0 Answers  

What is always encrypted?

0 Answers  

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

Define constraints and give an example of their use?

0 Answers  

What is checkpoint process in the sql server?

0 Answers  

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

What is the advantage of sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories