Home » RDBMS Server » Server Administration » Re: Optimizer hints - help needed
Re: Optimizer hints - help needed [message #369609] Fri, 03 November 2000 08:32
jag Anegondi
Messages: 3
Registered: November 2000
Junior Member
Hi,

Oracle chooses index scan if the indexed column appears in the where clause.As, you are not using any where clause index never comes into picture.

You check this:

SQL> select /*+ index_desc(xx ik) */ * from xx;

X
----------
11/03/2000
10/03/2000
09/03/2000
10/03/2000
06/03/2000
08/03/2000

6 rows selected.

SQL> select /*+ index_desc(xx ik) */ * from xx
2 where x <sysdate;

X
----------
11/03/2000
10/03/2000
10/03/2000
09/03/2000
08/03/2000
06/03/2000

6 rows selected.

Here x is indexed.

I hope this helps.

Thanks

Jag

Report message to a moderator

Previous Topic: Problem with Pro*c in Oracle 8i( Japanese)
Next Topic: Check to see if a field has a valid to_number ability
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 21:53:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.