Do i need to create an index CDHDR?

[ricky_shaw]

Hi,
I am querying CDHDR table with below fields.

OBJECTCLAS
OBJECTID
UDATE

I see some 4 indexes already created with one Z1(say) Index created with below 2 fields

OBJECTCLAS
UDATE

which means i am using extra field in my above query:

Is it a good idea to create another Index with extra field(like below) for my requirement?

OBJECTCLAS
OBJECTID
UDATE
Pls suggest.

[ricky_shaw]

Hi, Can anyone suggest please

[Sandra_Rossi]

It's a database-dependent question. Please tag your question with the concerned database. Note that you should first test your application with real data and then analyze if any performance issues.

[ulrich_mhrke]

The first two fields of the primary index are OBJECTCLAS and OBJECTID. I assume that there aren't many entries for the same combination of OBJECTCLAS and OBJECTID. Therefore, I don't think another index is necessary.

Can you run transaction TAANA in the relevant system? Then you can use this transaction to analyze the number of identical combinations of OBJECTCLAS and OBJECTID.

[ricky_shaw]

Ok Thanks Sandra. I have HANA as the DB. How do i tag my question with the concerned database?

[Sandra_Rossi]

I guess: SAP Hana, Platform edition. I did it. Could also be S/4HANA.