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 significance of master, tempdb and model databases?

0 Answers  

Can we use trigger new in before insert?

0 Answers  

What is the stuff?

0 Answers  

How many full-text indexes can a table have?

0 Answers  

Does sql server 2000 clustering support load balancing?

0 Answers  

What is user stored procedure & it purpose?

4 Answers   Wipro,

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

How to add additional conditions in SQL?

0 Answers   Amdocs,

Define primary key?

0 Answers  

How to count duplicated values in a column in ms sql server?

0 Answers  

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories