very urgent issue regarding qury become slow
hi
we hae query which worked fine.but it is about 2 days which it's perfomance has been increased about 15 min while before it responced in less than 1 min.
query
SELECT /*+INDEX (table_name INDX)*/
MIN (col1)
FROM tps01_cards
WHERE col1 = 'xx'
AND col2 = 2010
AND col3 = 0
AND col4 > 7777
the only change which was made was due to error ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU11 we created another undo tbs.
and it has too much space.but query has been slow down extremely.
i need to mention
SELECT /*+INDEX (table_name INDX)*/
*
FROM tps01_cards
WHERE col1 = 'xx'
AND col2 = 2010
query
SELECT /*+INDEX (table_name INDX)*/
MIN (col1)
FROM tps01_cards
WHERE col1 = 'xx'
AND col2 = 2010
AND col3 = 0
AND col4 > 7777
the only change which was made was due to error ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU11 we created another undo tbs.
and it has too much space.but query has been slow down extremely.
i need to mention
SELECT /*+INDEX (table_name INDX)*/
*
FROM tps01_cards
WHERE col1 = 'xx'
AND col2 = 2010
0