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
- 4522 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 are constraints? : Sql server database administration
What is the current limitation of the size of SQL Azure DB?
What is ssl in sql server?
Can two tables share a primary key?
what's the maximum size of a row? : Sql server database administration
What is molap and its advantage? : sql server analysis services, ssas
What happens when converting big values to numeric data types?
Explain primary key, foreign key and unique key?
How do I find query history in sql server?
What is dirty page?
What is the language structure to add a record to a table?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Is it possible to create trigger on views?
Explain what is public role in sql server?
How to generate create procedure script on an existing stored procedure?
