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?
- 2 Answers
- 4701 Views
- I also Faced
- E-Mail Answers
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
Can one drop a column from a table?
How to convert numeric expression data types using the cast() function?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How can I check that whether automatic statistic update is enabled or not?
What are wait types?
Does view occupy space?
What are the different subsets of sql?
Why we use the openxml clause?
What is the primary use of the model database?
How to convert character strings into numeric values?
Equi join and non equi join is possible with sql server?
How to remove duplicate rows from table except one?
List out the different types of locks available in sql server?
What is normalization and what are the advantages of it?
What is standby servers? Explain types of standby servers.
