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?

Answer Posted / rama krishna

it depends on search critiria for view

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to list all user defined functions in the current database?

495


Suggest a method of joining two tables.

572


How to recompile stored procedure at run time?

548


Write an sql query to find first weekday of the month?

464


What is transaction server explicit transaction?

520






1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1511


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

651


How many databases can we create in a single server?

183


How to remove duplicate rows from table?

569


What are the database objects? : SQL Server Architecture

520


What is the correct order of the logical query processing phases?

505


What are the rendering extensions of ssrs?

105


What is the rdl file?

84


What is isnull() operator?

544


Does group by or order by come first?

520