Re: Optimizing Oracle Queries.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 4 Mar 2005 18:26:55 +0000 (UTC)
Message-ID: <d0a99f$92i$1@titan.btinternet.com>

The easiest way to get some good
advice on this one is to go to

http://asktom.oracle.com

Use the search facility with the two words

page web

There are a couple of useful articles in the first 10 listed that will probably give you some good ideas on how to proceed.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Jan 21st 2005






"Vel" <velmurugan.p_at_gmail.com> wrote in message 
news:1109957048.078658.174980_at_o13g2000cwo.googlegroups.com...


> Hi,

>

> I have to select a particular record / set of records when clicking

> page link  in web based applications.  For that I have designed the

> oracle query in the following manner...It works fine.. but when we

> working with the tables which is has more than a Million records, the

> response is very slow....How to optimize the query / Is there any other

> approach to get a particular record from the DB  quickly?

>

Received on Fri Mar 04 2005 - 12:26:55 CST