Re: Oracle 9.0.1.0.0 and the indexes ...

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Mon, 16 Jun 2003 05:37:05 -0500
Message-ID: <ver7k8n17d0c5@corp.supernews.com>

Use the sqltrace facility ( and tkprof) or explain plan to see the access paths.
(Information on how to do this is in the Tuning Guide)

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"logiclin" <member31237_at_dbforums.com> wrote in message news:3006315.1055757736_at_dbforums.com...
>
> Hi everybody !
>
> Anybody can help me. We installing our product onto Oracle 9.0.1.0.0,
> but the queries are very slow ... I think Oracle does'n use the
> created indexes.
> How can I check the Oracle use the indexes or not, or need to enable
> index using, or how to force to index using ?
>
> Thank you very much for answers !
>
> Joseph G.
>
> --
> Posted via http://dbforums.com
Received on Mon Jun 16 2003 - 05:37:05 CDT