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.

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

All Comments

Collapse -

to fetch the data in faster rate. urgent

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

First: use EXPLAIN PLAN command to view query execution plan. If index is not used use explicit hint in your select stmt
Second: if date range in your DB more than ~10 month, use index on date in master table

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums