Query Performance Issue [message #506735] |
Wed, 11 May 2011 01:47 |
|
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 #506746 is a reply to message #506736] |
Wed, 11 May 2011 02:10 |
|
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 #506825 is a reply to message #506735] |
Wed, 11 May 2011 07:18 |
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.
|
|
|