Table Index

[Former Member]

Has does a select know which index to use? Thanks.

[Former Member]

In DB2 and Oracle, I think it uses the database statistics.

The DBAs keep the statistics up to date by running transaction DB20 (or DB20ORA).

Rob

Message was edited by:

Rob Burbank

[Former Member]

Index is selected based on conditions in the select statement. A close match is done to choose the index.

Thanks,

- Cheers

[former_member182371]

Hi,

please do have a look at the following link:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/2007/09/19/indexinginSAP+Tables

Hope it helps.

Best regards.

[Former Member]

Hi Tom,

Index is selected based on the where clause of the select query.

SELECT * FROM MARA

where MATNR = '0000242342'.

Here Database would select from MARA based on MATNR. So if there is a index available on MATNR then that index would be used.

Best regards,

Prashant