log into sqlplus
Run the script ora8i/rdbms/admin/utlxplan.sql
(creates the plan_table)
set autotrace on
run your query and .....
start tuning
"Steve Johnson" <johnst_at_ncs.com> wrote in message news:ufq5u6am03kmcb_at_corp.supernews.com...
> If I have a concatenated index on tablea columns (a, b, c) and a query:
>
> SELECT count(*)
> FROM tablea,
> tableb
> WHERE tablea.a like 'AB%'
> AND tablea.b=tableb.b
> AND tablea.c=tableb.c
>
> Will columns b and c of the index on tablea be used in the query? It uses
> the index like I wanted but I don't get the speed I think I should which
> leads me to believe that it doesn't.
>
> Any help would be appreciated.
>
> Thanks...
> Steve
>
>
Received on Tue Jun 04 2002 - 15:12:50 CDT
