OraFAQ Forum: Performance Tuning » At the end of the road of my sql tuning

Home » RDBMS Server » Performance Tuning » At the end of the road of my sql tuning (oracle)

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

At the end of the road of my sql tuning [message #532302]

Mon, 21 November 2011 20:07

tigerxu
Messages: 1
Registered: November 2011
Location: china

Junior Member

Hi all,

Does my sql need any tuning??

1.
select distinct c.customer_id, c.cust_first_name || ' ' ||c.cust_last_name customer_name
from customers c, orders o
where c.customer_id = o.customer_id;

2.
select od.order_id, oi.product_id, oi.unit_price
from orders od, order_items oi
where od.order_id = oi.order_id and upper(oi.last_update_user) = 'MINNY';

can anyone help??

Report message to a moderator

Re: At the end of the road of my sql tuning [message #532303 is a reply to message #532302]

Mon, 21 November 2011 20:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested.

Report message to a moderator

Previous Topic:	Definition between 2 metrics "Physical Reads"
Next Topic:	Temp Tablespace running out of space (68 GB)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 12:48:01 CST 2024