Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4422 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
What do you mean by sql server 2005 express management tools?
How can we improve performance by using SQL Server profiler?
What is the advantage of sql server?
What do you mean by recursive stored procedure?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
How to execute a stored procedure in ms sql server?
What is shrink log file?
What are the differences between sql server and mysql.
What is bcnf normalization form?
how can you check the level of fragmentation on a table? : Sql server administration
What is meant by indexing?
Tell me what is fill factor?
What are different type of Collation Sensitivity?
What are different types of join?
How to update values in a table with update statements in ms sql server?
