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
- 4505 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 advantages of ssrs or why we should use ssrs?
Explain activity monitors
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Where is trigger in sql server?
How to find table changes in sql server?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is dml command?
How to reaname table name without using sp_Rename in sql server..?
How to apply filtering criteria at group level with the having clause in ms sql server?
What is the use of nvl work?
Can sql servers linked to other servers like oracle?
Explain query editor regions
Define inner join? Explain with an example?
How to handle error or exception in sql?
Explain indexing and what are the advantages of it?
