[10.2.0.4] About dynamic sampling
Hi,
A software is using the following query :
SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$IDX_FTIDX_PRIMARYFILE$X")*/ DISTINCT TOKEN_TEXT FROM FTUSER.DR$IDX_FTIDX_PRIMARYFILE$I T
WHERE TOKEN_TEXT LIKE :lkexpr ESCAPE '\'
and (TOKEN_TYPE IN (0, 4, 6, 604) OR (TOKEN_TYPE BETWEEN 16 AND 74) OR (TOKEN_TYPE BETWEEN 616 AND 674))
The AWR report says that that query consume 79 min for 6 executions (weak CPU time of 81 s and 4 cores processor).
When I look at the plan I've got a cost of 138811 and a cardinality of 15188560 (the table contains 17 000 000 lines).
According to you is there a problem with that query ? and in the case yes, do you have any idea for the solution ?
SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$IDX_FTIDX_PRIMARYFILE$X")*/ DISTINCT TOKEN_TEXT FROM FTUSER.DR$IDX_FTIDX_PRIMARYFILE$I T
WHERE TOKEN_TEXT LIKE :lkexpr ESCAPE '\'
and (TOKEN_TYPE IN (0, 4, 6, 604) OR (TOKEN_TYPE BETWEEN 16 AND 74) OR (TOKEN_TYPE BETWEEN 616 AND 674))
The AWR report says that that query consume 79 min for 6 executions (weak CPU time of 81 s and 4 cores processor).
When I look at the plan I've got a cost of 138811 and a cardinality of 15188560 (the table contains 17 000 000 lines).
According to you is there a problem with that query ? and in the case yes, do you have any idea for the solution ?
0