Home » RDBMS Server » Performance Tuning » Output of Query is very slow through SQL
Output of Query is very slow through SQL [message #262702] Tue, 28 August 2007 01:46 Go to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
Whenever we are writing any complex queries from SQL Plus the Output is very slow , it takes around 20-30 minutes to extract 30000 records.

Mostly from queries like
select x,y,z,
(select a from xtab where a=btab.x)n
from btab

Can anyone suggest any tuning parameters.

Thanks

Sarfraz
Re: Output of Query is very slow through SQL [message #262703 is a reply to message #262702] Tue, 28 August 2007 01:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Insufficient information.

please provide us below details.

1. table structure.
2. total no. of records in table
3. index
4. execution plan or tkprof or 10046

Regards
Taj
Re: Output of Query is very slow through SQL [message #262877 is a reply to message #262702] Tue, 28 August 2007 07:20 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
use index on column which exists on where clause
Re: Output of Query is very slow through SQL [message #262901 is a reply to message #262877] Tue, 28 August 2007 08:22 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why not putting the second table in from clause and use a (outer) join and a hash join?

Regards
Michel
Previous Topic: DBMS_APPLICATION_INFO Usage
Next Topic: CBO vs RBO
Goto Forum:
  


Current Time: Sun Dec 04 16:27:26 CST 2016

Total time taken to generate the page: 0.11576 seconds