SQL Performance (MOSC)

MOSC Banner

I cant understand why is index used with item 00123 and not with 00938, same SQL

edited May 23, 2013 6:41AM in SQL Performance (MOSC) 27 commentsAnswered
Hi,
anybody have an idea why index is not used with item 00938, but 00123 do? I have already rebuild the index, but no change.

SQL:
SELECT LAGORT.ARTNR AS C1, LAGORT.LAGERORTNR AS C2, LAGORT.LAGERPLATZ AS C3, LAGORT.MENGE AS C4, LAGORT.LAGERORTNR AS C5, LAGORT.ISAVAILABLEQTY AS C6
FROM LAGORT
WHERE LAGORT.ARTNR = '00123';


42 Zeilen ausgewählt.


Ausführungsplan
----------------------------------------------------------
Plan hash value: 635348658

-------------------------------------------------------------------------------------------
| Id  | Operation                   | Name        | Rows  | Bytes | Cost (%CPU)| Time     |
-------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |             |    57 |  1482 |    33   (0)| 00:00:01 |
|   1 |  TABLE ACCESS BY INDEX ROWID| LAGORT      |    57 |  1482 |    33   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN          | IX_LAGORT01 |    57 |       |     1   (0)| 00:00:01 |
-------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("LAGORT"."ARTNR"='00123')

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