Regarding Index

[Former Member]

Hi All,

i want to know my secect query which index is using because in data base for EBAN table there are several indexes are there.

can i see that from st05?

if yes then how?

Regards,

Amit.

[Former Member]

Hi All,

i want to know my secect query which index is using because in data base for EBAN table there are several indexes are there.

can i see that from st05?

if yes then how?

Regards,

Amit.

[Former Member]

hi amit

go to se14

[Former Member]

you can go to ST05 transaction and start the trace and run your program. Stop the trace and use the explain button in the application toolbar for your select statement.

it would tell you which index has been used.

Regards

Vasu

[Former Member]

HI,

You can check by seeing the select statment, if that is not using any index then the select statment is using the primary index,

if the select is using the seconday index,

SELECT carrid connid cityfrom

FROM spfli INTO (xcarrid, xconnid, xcityfrom)

WHERE carrid = 'LH ' AND cityfrom = 'FRANKFURT'

%_HINTS ORACLE 'INDEX("SPFLI" "SPFLI~001")'.

WRITE: / xcarrid, xconnid, xcityfrom.

ENDSELECT.

You can see which index is using, the index name is 001 ( secondary index name is from SPLFI~<b>001</b>) ... you can check this in SPLFI table

Regards

Sudheer