Interested to Buy Any Domain ? << Click Here >> for more details...
There is a table, In one column it has implemented a index,
but the index is disturbed by the regular dml statements..
but still we need to keep the index. how it is possible?
- 1 Answers
- 6558 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer / a.v.r.murthy
GENERALLY INDEX WILL BE CREATED ON LESS NUMBER OF DML
OPERATION COLUMNS.
EVENTHOUGH IF WE WANT PERFORM BETTER THEN BEFORE INSERTING
DATA INTO THE COLUMN WE HAVE TO DISABLE THE INDEX i.e
ALTER INDEX IDX_NAME UNUSABLE;
| Is This Answer Correct ? | 7 Yes | 0 No |
Is left join inner or outer by default?
Explain the difference between rename and alias?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
How much does sqlite cost?
how to include numeric values in sql statements? : Sql dba
what is a trigger? : Sql dba
Is pl sql useful?
Explain architecture of sql server notification services?
What is delimiter sql?
What is cte sql?
how to get a list of columns in an existing table? : Sql dba
What is java sql connection?
-
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)
