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
- 4617 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 is the security principal at the server level that represents your session?
How to optimize stored procedure optimization?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to change parameter value inside the report?
What are the built in functions in sql server?
why would you use sql agent? : Sql server database administration
What is an example of a primary key?
What are different types of table joins?
How to use linked server?
Describe in brief databases and sql server databases architecture.
What are the disadvantages of using querystrings to send data from one page to another?
What are the advantages of user defined function?
role of sql sever 2005 in database rather than any other database
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What are the three different part of rdl file explain them?
