Interested to Buy Any Domain ? << Click Here >> for more details...
Give the reasoning behind using an index.
- 2 Answers
- 8781 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mathavan
Indexes are used for faster access of required data in a
large table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rajesh naidu
INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA
| Is This Answer Correct ? | 5 Yes | 0 No |
How can we know the exact updation date of a particular database?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how does an oracle clusterware manage crs resources?
Explain the concept of the DUAL table.
How do you switch from an init.ora file to a spfile?
What purpose does the model database server? : sql server DBA
What is transparent data encryption? : sql server DBA
You have just compiled a PL/SQL package but got errors, how would you view the errors?
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
Name a tablespace automatically created when you create a database.
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
what is logical system in sap basis
-
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)
