How do you select an index for a table
Answer / neha_gupta
The index for a table is selected , if there is a column
which is getting repetedly called in your queries.
On the data of the table the type of index can be selected.
| Is This Answer Correct ? | 0 Yes | 2 No |
Is database a hardware or software?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is the advantage of varchar2 over char?
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
Is data lake a database?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
Differentiate between delete and truncate table?
what is rcp,if rcp disabled what happen?
How heap is implemented in database?
what is the difference between relational calculus and relational algebra ?
What is sharded database?
What is the differnce between Order by and Group by
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)