topic Re: Primary index Usage in Application Development and Automation Discussions

Primary index Usage

Former Member — Wed, 20 Dec 2006 07:19:52 GMT

HI GURUS,

I want to know about primary index that how system use it.

Like I am quering a table 'BSAK' which have 10 key fields. And in my query i am mentioning 4 key fields from different locations like 1, 3, 6, and 9 key field. and 1 non key field.

Now what database will do. It will use the primary index or not.

and is it important to mention client field 'mandt' when quering which is also a key field.

Thanks in advance

Re: Primary index Usage

Former Member — Wed, 20 Dec 2006 07:28:51 GMT

though u dont use, you have to all the key fields in the select statement in the order, along with your non-key field. that can work.

pavan

Re: Primary index Usage

Former Member — Wed, 20 Dec 2006 07:32:47 GMT

Hi,

The query will work fine. No problem in that.

And u do not have to mention 'MANDT' field in query.

Rgds,

Prakash

Re: Primary index Usage

Former Member — Wed, 20 Dec 2006 07:32:59 GMT

Hi,

As per my knowledge, if we have 10 fields as primary keys, index is going to maintain for the composite primary key, if you specifiy all primary keys in your select statement data retrival will be very fast because it going to find what is the exact record for composite key, other wise it is going to check all the records matching to your where condition and retrive all this will cause major performance issue.

Re: Primary index Usage

Former Member — Wed, 20 Dec 2006 07:39:58 GMT

HI Mehra,

Question is not about query will work fine or not. But i want to know that if system will use the primary index for searching of record or not.

If we have 10 key fields and we mention 4 or 5 key fields and a non key field.

system will use the primary index or not????

Thanks

Re: Primary index Usage

Former Member — Wed, 20 Dec 2006 07:46:25 GMT

Hi ,

No . It wont use Primary Index . It will search all the records .

If we want to increase the performance we can create secondary index

using those 4 fields alone .

Regards ,

Senthil