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
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
System variable and temporary variables
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Can the “if update (colname)” statement be used in a delete trigger?
How to create a ddl trigger using "create trigger" statements?
When we should use and scope of @@identity?
What were the latest updates to SQL Azure service?
Explain the commands in sql server?
What information is maintained within the msdb database?
Explain Capacity planning to create a database? and how to monitor it?
What is data set in report?
List the advantages of using stored procedures?
How to change server name in sql server?
How to insert new line characters into strings?
If we delete pack Spec what will be the status of pack Body ?