Dynamic sample over intermedia index
Hello everyone I have some kind of issue on my intermedia search always can see this query
SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$FF4_CONTAINER_CTXIDX$X")*/ DISTINCT
TOKEN_TEXT FROM "DR$FF4_CONTAINER_CTXIDX$I" T WHERE TOKEN_TEXT LIKE
:lkexpr and (TOKEN_TYPE = 0 OR TOKEN_TYPE = 4 OR TOKEN_TYPE BETWEEN 16
AND 74)
and most of times it is too slow it take so much time to resolve and I cant find where is he or why is doing it.
I have searched a lot and i cant find any useful info.
Anyone knows what it does and how to disable
SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$FF4_CONTAINER_CTXIDX$X")*/ DISTINCT
TOKEN_TEXT FROM "DR$FF4_CONTAINER_CTXIDX$I" T WHERE TOKEN_TEXT LIKE
:lkexpr and (TOKEN_TYPE = 0 OR TOKEN_TYPE = 4 OR TOKEN_TYPE BETWEEN 16
AND 74)
and most of times it is too slow it take so much time to resolve and I cant find where is he or why is doing it.
I have searched a lot and i cant find any useful info.
Anyone knows what it does and how to disable
0