Home » RDBMS Server » Performance Tuning » Query optimization
Query optimization [message #128227] Fri, 15 July 2005 17:37 Go to next message
Hina
Messages: 51
Registered: April 2004
Member
How to optimize following query?

SELECT analyst_id,
       employee employee_name
FROM   employee_alias
WHERE  indicator = 'F'
UNION
SELECT analyst_id,
       employee_name
FROM   employee
/
Re: Query optimization [message #128235 is a reply to message #128227] Fri, 15 July 2005 22:56 Go to previous messageGo to next message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
Read the Oracle Performance Tuning Guide, especially the sections about Optimizing SQL Statements and how to do a simple Explain Plan.

Best regards.

Frank
Re: Query optimization [message #128238 is a reply to message #128235] Fri, 15 July 2005 23:47 Go to previous messageGo to next message
Hina
Messages: 51
Registered: April 2004
Member
Hi Frank,

I already tried, but could not find a solution that's why I posted on this forum.



Regards
Re: Query optimization [message #128256 is a reply to message #128238] Sat, 16 July 2005 04:06 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
Yes, that is why you need to read the Performance Tuning Guide. It will enable you to do an explain plan and get some execution statistics. Without it, you would not know what's happening, nor will anyone else be able to help you.

Best regards.

Frank
Previous Topic: /*+ RULE */ hint in SQL Queries
Next Topic: The Server Performance deteriorates after some time after the instance is restarted
Goto Forum:
  


Current Time: Thu Feb 02 06:02:32 CST 2023