Home » RDBMS Server » Performance Tuning » At the end of the road of my sql tuning (oracle)
icon3.gif  At the end of the road of my sql tuning [message #532302] Mon, 21 November 2011 20:07 Go to next message
tigerxu
Messages: 1
Registered: November 2011
Location: china
Junior Member
Embarassed

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??




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 Go to previous message
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.
Previous Topic: Definition between 2 metrics "Physical Reads"
Next Topic: Temp Tablespace running out of space (68 GB)
Goto Forum:
  


Current Time: Fri Mar 29 08:38:01 CDT 2024