Answer Posted / anindya basu
An indexed view is a part of the database and is saved to the disc. Creating an index on a view turns the latter into a permanent database object since indexes are so. Consequently every time the view is invoked, it gets loaded from the disc and need not be recreated.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we improve performance by using SQL Server profiler?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Which tcl commands are available on the sql server?
Where in ms sql server is ’100’ equal to ‘0’?
How to install sql server 2005 express edition?
what are the critical issues you have resloved in your company
In what sequence sql statement is processed?
Where are sql server usernames and passwords stored in the sql server?
What factors you will consider calculating the storage requirement for that view?
What is data modeling and Reterminal integrity?
What happens if ntwdblib.dll is missing on your machine?
What are the different normalization forms?
Which is faster statement or preparedstatement?
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?
Explain ranking functions?