for all entries & secondary indexes

[Former Member]

HI all,

Is the any relation b/w For all entries and Secondary indexes in performence wise.

regards,

ajay

[former_member203501]

hi please know the difference between these two .

secondary index is used when the data fetching is taking more time , means there was a bulk data processing . it shows a good performane .

[Former Member]

Hi Venkat,

How to i intimate that this is the secondary index field .. in the select stmt.

regards,

Ajay

[Former Member]

Hi,

We use for all entries rather than using inner joins for performance.

& secondary index for bulk data processing.

Tks,

Krishna

[Former Member]

Hi ,

then you are sure aware of the drawbacks of FAE?

I'm not against FAE but...

DO 100 TIMES.
 
  write: JOINS are not always evil.
  write: FAE is not always good.
 
ENDDO.

Be aware that FAE just combines the internal table entries into IN's , OR conditions or UNIONS depending on rsdb parameters (see SAP Note 48230) what will kill you if you have a lot of entries in the FAE table.

see SAP Note 48230 - Parameters for the SELECT ... FOR ALL ENTRIES statement

bye

yk

[former_member194613]

there is no relation between FOR ALL ENTRIES and secondary keys.

there is neither a relation between secondary key and bulk processing.

A SELECT has a WHERE condition depending on your conditions and on the information

you need to know.

But the primary key can only support search with fields which are in the table key.

If you WHERE condition has other fields, then you need a secondary key to support other searches.

I don't know a blog on indexes, but check wikipedia for indexes. It is definitely explained how they are used!!

Siegfried