Re: Indexes, Increase query speed

In order to understand why your query is running slow, you'll have to use EXPLAIN PLAN. This is fully documented in the Oracle Performance and Tuning Guide. Without a posted EXPLAIN PLAN, the best anyone here can do is guess.

HTH,
Brian

WiltonD_at_state.mi.us wrote:
>
> Hi,
> I'm a new developer and I want to increase the speed of my queries
> retrieved in Forms 6.0.
> I have a master - detail1 - detail2 (Table1 - Table2 - Table3)
> relationship. Where detail1(Table2) is the master of detail2(Table3).
> I have a two forms based on the above relationship. One form has the
> data source set to the tables (3 data blocks), the other form is based
> on a view of all three tables (1 data block).
> For both forms I need to auto query when the form opens
> Ordered by Table1 name and table2 date.
> I have indexes on all primary keys and foreign keys.
> I also created the following indexes:
> Table1 (primary key and name)
> Table2 (primary key, foreign key)
> Table2 (primary key, date)
> The queries are still quite slow any advice?
> What have I done wrong?
>
> Thanks
> Dave
>
> Sent via Deja.com
> http://www.deja.com/
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================