Re: Oracle 9.0.1.0.0 and the indexes ...

Thank you very much for help, we try to DBMS_STATS for analyze tables.

"
> Also a full table scan is not always slower than
> using an index. It depends.
> "
>
> We try to use indexes, because queries on this tables with indexes
> faster more than 5-15 times on DB2 v7.2 than without indexes. So I
> think the index using mandatory in this case.
>
> Thank you again !
> Joseph G.

--
Posted via http://dbforums.com