topic Re: Index... in Application Development and Automation Discussions

Index...

Former Member — Tue, 06 Dec 2005 10:54:16 GMT

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

ur views....

Re: Index...

Former Member — Tue, 06 Dec 2005 10:56:58 GMT

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

Re: Index...

abdul_hakim — Tue, 06 Dec 2005 10:59:05 GMT

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

Re: Index...

Former Member — Tue, 06 Dec 2005 11:00:48 GMT

Abhishek Suppal

No need to consider the MANDT.

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

Thanks

Kam

Re: Index...

Former Member — Tue, 06 Dec 2005 11:01:30 GMT

Not required..

try to create secondary index with out considering MANDT.

regards

vijay

Re: Index...

Former Member — Tue, 06 Dec 2005 11:10:07 GMT

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

Re: Index...

Former Member — Tue, 06 Dec 2005 11:11:45 GMT

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.

Re: Index...

Former Member — Tue, 06 Dec 2005 11:52:20 GMT

Hi,

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

Regards,

Amit M.

Re: Index...

Peranandam — Sat, 13 Feb 2010 03:25:07 GMT

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.