Home » RDBMS Server » Performance Tuning » Tuning Issue Urgent
Tuning Issue Urgent [message #64942] Sun, 14 March 2004 18:49 Go to next message
ora
Messages: 47
Registered: June 2002
Member
Hi,

I have a query which is needed to run monthly, which pick all the relevant information about all the available policies from different tables and dump all the records into a table for further processing.

The problem is, there are about 6,00,000 policies in the database, and fetching this number of records and dumping the same in a table is really...

Now i want to know the best approach to do this. At query level it is properly tuned. now the question is should i use a single query e.g. insert into select ... or should i go for a cursor and issue commit after some number of records? Along with all that also suggest me about how to reduce the total time taken by the query.
Re: Tuning Issue Urgent [message #64946 is a reply to message #64942] Mon, 15 March 2004 10:54 Go to previous message
ABC
Messages: 13
Registered: March 2001
Junior Member
use insert into or create table... as select
Previous Topic: Local schema vs. public schema
Next Topic: Tips
Goto Forum:
  


Current Time: Fri Mar 29 03:00:12 CDT 2024