topic Re: Table Index in Application Development and Automation Discussions

Table Index

Former Member — Thu, 27 Sep 2007 18:10:39 GMT

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

Former Member — Thu, 27 Sep 2007 19:01:51 GMT

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 — Thu, 27 Sep 2007 20:47:02 GMT

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

Thanks,

- Cheers

former_member182371 — Thu, 27 Sep 2007 21:09:12 GMT

Hi,

please do have a look at the following link:

Hope it helps.

Best regards.

Former Member — Fri, 28 Sep 2007 04:00:16 GMT

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