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?
What is the default identifier of structure in C?
What is ase database?
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
What is the candidate key used for?
can anyone please tell what are the roles and responsibilities of a teradata developer in detail???
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What do you mean by foreign key and primary key?
What is the database url?
Explain database partitioning.
what is the full procedure for using store procedure in informatica7.1?
Datatypes are unlimited,true or false?
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)