mentioning the index in the select query?

[Madhurivs23]

Hi All,

I want to write a query on AUFM table having where condition for AUFNR field. This table has 2 secondary indexes.

1st one on {MATNR,CHARG,WERKS, BWART,BUDAT}

and 2nd one on

I want to specify 2nd index in my select query . How can I mention that in select query?

rgds,

Madhuri

[Sm1tje]

Database optimizer does this for you. Just use this field in your selection and leave the rest to the database.

[Former Member]

When you make use of AUFNR only in ur select query then automatically secondary index pertaining to that would be invoked.