Discussion Locked

to fetch the data in faster rate. urgent

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am now working on Oracle 8i in Windows NT 4.0 platform. It has 1GB of ram size. I have a table called master and child table having a relation with 8 fields. my child table has around 4 lakh records. when i run Oracle report to retrieve one monthdata, it takes more than half an hour to produce the report. i created index on these fields and i couldn't able to reduce the time.

help me to fetch the data much faster rate. urgent

5 replies

by jaikumar

Use Explain Plan Of Oracle and find out where the problem is. Explain Plan can easily identify why there is a lag in retrieving and it also suggests what field has to be indexed.

by timthetoolman

Hi,

The above answer is good and will probably help you solve it. But if you want us to help you specifically you're going to have to give us much more information.

Like...

Table definitions (including indexes) and cardinalities.

AND... how you're accessing them. Preferably the SQL statements themselves but an outline plan would probably do.

Cheers,
Tim.

This discussion is closed to new replies.