Interested to Buy Any Domain ? << Click Here >> for more details...
Explain indexed view?
- 1 Answers
- 1497 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to provide default values to stored procedure parameters?
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is system stored procedures?
How many clustered indexes there can be on table ?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
What are the differences between decimal and float in ms sql server?
How to list all login names on the ms sql server?
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
What is normalization? Describe its different types.
how to find the second salary?
-
Oracle (3253) - 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)
