Re: Index hints are not working

Hi,

Im am measuring the time a query takes is ms ( 1 to 5 ms !!!!). To total time of all query's are even calculates at the nano seconds to make sure there are no rounding factors.

So when i use a ORDER BY i get the records the way I want. But its WAY TO SLOW. My application is running on: SOLID / MSSQL 7.0 / INFORMIX / SYBASE without performance problems. But on ORACLE its now or the SLOW or not giving the right result (Records not ordered on index).

Regards Klaas.

michael_bialik_at_my-deja.com wrote in message <8aap8d$9rg$1_at_nnrp1.deja.com>...
>Hi.
>
> 1. SELECT /*+ INDEX(DS001 IDX_DS001A) */ * FROM DS001
> is supposed to do a FULL table scan because no WHERE/ORDER BY
> clause exists.
>
> 2. Make an EXPLAIN for:
> SELECT /*+ INDEX(DS001 IDX_DS001A) */ * FROM DS001
> ORDER BY SW_DS001A , DS001FD1
> - It is supposed to use index.
> Don't worry if that select takes a lot of time, because it
> accesses index AND data parts of table ( vs. FULL scan that
> accesses only data and using SORT ).
> As you wrote yourself the application program will stop after N
> first records.
>
> HTH. Michael.
>
Received on Fri Mar 10 2000 - 00:00:00 CST