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
- 4544 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sql2000
Lets start on what a view is, view is a name given to a
select statement. The select statement is executed when the
view name is called.
When you create index on the view the select statement is
materialized into a table and we have the contents of the
select statement as a table. This makes it faster at times
to run select statements on rather than the actual tables.
Hence it makes sense to create indexes on views.
Let me know if anyone has a better point of view on
this. :)
| Is This Answer Correct ? | 0 Yes | 0 No |
What is create command?
What's the purpose of Stored Procedure?
Differentiate between ms sql server reporting services vs crystal reports?
What is key set driven?
List all types of constraints in sql server?
Why main is user defined function?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
How can sql server instances be hidden? : sql server security
What do you understand by user-defined function in the sql server?
How to write a script for upate the data in prod , i have 50000 row are there
What is the difference between grant and with grant while giving permissions to the user?
What are alternate keys?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
