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