topic Re: Regarding Index in Application Development and Automation Discussions

Regarding Index

Former Member — Thu, 13 Sep 2007 13:06:36 GMT

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.

Re: Regarding Index

Former Member — Thu, 13 Sep 2007 13:09:36 GMT

hi amit

go to se14

Re: Regarding Index

Former Member — Thu, 13 Sep 2007 13:11:09 GMT

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

Re: Regarding Index

Former Member — Thu, 13 Sep 2007 13:13:51 GMT

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