SQL Performance (MOSC)

MOSC Banner

Tune query

edited Nov 20, 2013 2:42AM in SQL Performance (MOSC) 3 commentsAnswered
Hi,

Please help me tune below query.

SELECT me.vac_ref, me.job_title, me.location, me.email FROM (SELECT me.vac_ref, me.job_title, me.location, me.email  FROM VACANCY me  ORDER BY vac_ref ASC) me WHERE ROWNUM <= :rowcount;

Explain Plan output
-------------------
--------------------------------------------------------------------------------
| Id  | Operation               | Name    | Rows  | Bytes |TempSpc| Cost (%CPU)|
--------------------------------------------------------------------------------
|   0 | SELECT STATEMENT        |         |    21M|  4489M|       |  2129K  (1)|
|   1 |  COUNT STOPKEY          |         |       |       |       |            |
|   2 |   VIEW                  |         |    21M|  4489M|       |  2129K  (1)|
|   3 |    SORT ORDER BY STOPKEY|         |    21M|  1848M|  4267M|  2129K  (1)|
|   4 |     TABLE ACCESS FULL   | VACANCY |    21M|  1848M|       |  1682K  (1)|
--------------------------------------------------------------------------------

Regards
Raj

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center