General discussion

Locked

to fetch the data in faster rate. urgent

By mohanraj2000 ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

to fetch the data in faster rate. urgent

by Jaikumar In reply to to fetch the data in fast ...

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.

Collapse -

to fetch the data in faster rate. urgent

by mohanraj2000 In reply to to fetch the data in fast ...

The question was auto-closed by TechRepublic

Collapse -

to fetch the data in faster rate. urgent

by TimTheToolMan In reply to to fetch the data in fast ...

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.

Collapse -

to fetch the data in faster rate. urgent

by mohanraj2000 In reply to to fetch the data in fast ...

The question was auto-closed by TechRepublic

Collapse -

to fetch the data in faster rate. urgent

by mohanraj2000 In reply to to fetch the data in fast ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums