SQL Performance (MOSC)

MOSC Banner

Query with index hint don't give back a result

Hi

i have this problem

----------------------------------------------------------------

SELECT /*+ index(t indexname) */ *

 FROM schema.tablename t

WHERE t.colum name = 3453454534;

----------------------------------------------------------------

returns zero rows

the query without index hint

----------------------------------------------------------------

SELECT SELECT /*+ parallel (t,16) no_index(t) */ *

 FROM schema.tablename t

WHERE t.colum name = 3453454534;

----------------------------------------------------------------

give back 3 rows


Database Version Oracle 18C


now is the question,

is it a failure in the script,

exist some known bugs!


br

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center