topic Re: OPtimizing Performance for Select query on NAST table in Application Development and Automation Discussions

OPtimizing Performance for Select query on NAST table

Former Member — Fri, 06 Jul 2007 14:54:09 GMT

Hi All,

We are fetching a single record from NAST table. The table has around 10 Million Entries.

The Select Query takes around 5-6 minutes to return.

We are not using the Primary key completely. We are using only one field of the primary key.

The field is also a part of the Index but we are not using all the fields in the index as well.

We need to bring down the time. What can be the solution? I cant see any changes to the code, since its a single query and we cant use the Entire Primary key.

Would creating an Index on the fields that we are concerned with help in this regard.

Open to all solutions.

Thanks in Advance,

Imran

Re: OPtimizing Performance for Select query on NAST table

Former Member — Fri, 06 Jul 2007 15:17:32 GMT

Hi Imran,

do you have few more conditions to add to reduce search area?

Re: OPtimizing Performance for Select query on NAST table

former_member194669 — Fri, 06 Jul 2007 15:29:01 GMT

Hi,

Please check this thread

http://sap.ittoolbox.com/documents/popular-q-and-a/specifying-the-index-to-be-used-2462

For creating another secondary index in NAST whether basis will approve for this?

aRs

Re: OPtimizing Performance for Select query on NAST table

Former Member — Fri, 06 Jul 2007 15:36:08 GMT

Hi,

Please post the SQL for nast and make sure you use one of the indexes in the table..

Thanks

Naren