Index...

[Former Member]

is it recommended that while creating Seconday Index on a table that we shud consider MANDT in it also...

ur views....

[Former Member]

Hi Abhishek,

1. No

Primary index takes care of that. (Mandt)

2. The fields which are commonly used

in our SQL queries

for filtering the data :

Such fields are the target

for secondary indexes.

(Such fields may not be a part of the

primary key of that table)

I hope it helps.

Regards,

Amit M.

Message was edited by: Amit Mittal

[abdul_hakim]

Hi,

No Not required because when u define a primary key then u should select MANDT as well since u cannot have a key field in between non key field.

Finally it is not at all requried.

Enjoy!!

REgards,

Abdul

[Former Member]

Abhishek Suppal

No need to consider the MANDT.

Just collect the fields to be in Sec Index and create it.

Thanks

Kam

[Former Member]

Not required..

try to create secondary index with out considering MANDT.

regards

vijay

[Former Member]

thanx but if MANDT is consider in some index will it effect some performance.....

[Former Member]

Hi again,

1. Yes

If MANDT is considered in secondary index again,

it will affect performance a little.

But not to worry about it.

Regards,

Amit M.

[Former Member]

Hi,

1. Pls award points if any reply(s) are useful.

Regards,

Amit M.

[Peranandam]

its better to keep MANDT field in secondary index. because while accessing table data across client table data will not be sorted if you are not maitained MANDT field in secondary index.