OraFAQ Forum: Performance Tuning » Output of Query is very slow through SQL

Home » RDBMS Server » Performance Tuning » Output of Query is very slow through SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Output of Query is very slow through SQL [message #262702]

Tue, 28 August 2007 01:46

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

Report message to a moderator

Re: Output of Query is very slow through SQL [message #262703 is a reply to message #262702]

Tue, 28 August 2007 01:48

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

Report message to a moderator

Re: Output of Query is very slow through SQL [message #262877 is a reply to message #262702]

Tue, 28 August 2007 07:20

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

use index on column which exists on where clause

Report message to a moderator

Re: Output of Query is very slow through SQL [message #262901 is a reply to message #262877]

Tue, 28 August 2007 08:22

Michel Cadot
Messages: 68665
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

Report message to a moderator

Previous Topic:	DBMS_APPLICATION_INFO Usage
Next Topic:	CBO vs RBO

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 06:03:35 CDT 2024