Home » RDBMS Server » Performance Tuning » Query Performance Issue (Oracle SQL Developer, v1.0.14.67)
icon7.gif  Query Performance Issue [message #506735] Wed, 11 May 2011 01:47 Go to next message
abdulrahaman288
Messages: 5
Registered: May 2011
Location: Bangalore
Junior Member

Hi,

I've written query to fetch the data from server by comparing values from two tables. I'm getting performance issue, its taking reasonablly more time to do. Below find my query.

SELECT a.id
, a.name
, a.type
, b.assign
, b.standard
FROM meta b
, vision a
WHERE b.ID = a.ID
AND a.status = 'RELEASED'
AND a.state = 'Y'
AND a.type = 'Template'
AND Default = 'YES'
AND Format = 'Mixed'
AND Layout = 'Narrow'
AND assign IN('x','y');
Re: Query Performance Issue [message #506736 is a reply to message #506735] Wed, 11 May 2011 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel
Re: Query Performance Issue [message #506746 is a reply to message #506736] Wed, 11 May 2011 02:10 Go to previous messageGo to next message
abdulrahaman288
Messages: 5
Registered: May 2011
Location: Bangalore
Junior Member

SELECT a.id
, a.name
, a.type
, b.assign
, b.standard
FROM meta b
, vision a
WHERE b.ID = a.ID
AND a.status = 'RELEASED'
AND a.state = 'Y'
AND a.type = 'Template'
AND Default = 'YES'
AND Format = 'Mixed'
AND Layout = 'Narrow'
AND assign IN('x','y');
Re: Query Performance Issue [message #506756 is a reply to message #506746] Wed, 11 May 2011 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 11 May 2011 08:50
Read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

Re: Query Performance Issue [message #506758 is a reply to message #506736] Wed, 11 May 2011 02:55 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Michel Cadot wrote on Wed, 11 May 2011 12:20
Read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

Re: Query Performance Issue [message #506825 is a reply to message #506735] Wed, 11 May 2011 07:18 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Hi,
In short,
Kindly:
1)Format your sql query.
2)Post the explain plan.Possibly Trace your query and post TKPROF output.
3)Post the number of rows contained in both the tables.
4)Post the list of indexes created on these tables.
Previous Topic: ORA-01555
Next Topic: composite index
Goto Forum:
  


Current Time: Thu Mar 28 08:32:49 CDT 2024