OPtimizing Performance for Select query on NAST table

[Former Member]

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

[Former Member]

Hi Imran,

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

[former_member194669]

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

[Former Member]

Hi,

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

Thanks

Naren