top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How you will avoid your query from using indexes in Oracle?

+1 vote
422 views
How you will avoid your query from using indexes in Oracle?
posted Jun 2, 2015 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

SELECT * FROM emp Where emp_no+' '=12345; i.e you have to concatenate the column name with space within codes in the where condition. SELECT /*+ FULL(a) */ ename, emp_no from emp where emp_no=1234; i.e using HINTS

answer Jun 3, 2015 by Arun Gowda
...