There is a table, In one column it has implemented a index, but the index is d

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?

Question Posted / guest

1 Answers
6460 Views
Cognizant, I also Faced
E-Mail Answers

There is a table, In one column it has implemented a index, but the index is disturbed by the regu..

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

Post New Answer

More SQL PLSQL Interview Questions

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers

What is the left table in sql?

0 Answers

What is cascade in sql?

0 Answers

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers Fujitsu,

What is an escape character in sql?

0 Answers

What are different types of sql?

0 Answers

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers

difference between pl/sql table and normal pl/sql table

2 Answers

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers

What are triggers in sql?

0 Answers

Is sql an operating system?

0 Answers

what are dynamic queries in t-sql? : Transact sql

0 Answers

For more SQL PLSQL Interview Questions Click Here