Give the reasoning behind using an index.
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 |
wat is global index and local indes
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is asm?
any body know about orawaves do they really provide placements in their unique placement program
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
Explain the difference between a data block, an extent and a segment.
how to restore files with rman?
how can you process messages in order asynchronously?
why do we give pctfree and pctused in create table statement?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
Name three advisory statistics you can collect.
What are the ways tablespaces can be managed and how do they differ?
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)