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
How to list all user defined functions in the current database?
Suggest a method of joining two tables.
How to recompile stored procedure at run time?
Write an sql query to find first weekday of the month?
What is transaction server explicit transaction?
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?
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
How many databases can we create in a single server?
How to remove duplicate rows from table?
What are the database objects? : SQL Server Architecture
What is the correct order of the logical query processing phases?
What are the rendering extensions of ssrs?
What is the rdl file?
What is isnull() operator?
Does group by or order by come first?