We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Maxdb Table Index problem

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Andre54 (MR)
on Jul 7 at 12:21 AM 		Mark this reply as helpfulMark as helpful
Problem solved
Did Update stats on all tables and program runs 100%
Thanks

---------------Original Message---------------
From: Andre54
Sent: Tuesday, July 06, 2010 3:40 AM
Subject: Maxdb Table Index problem

> Hi All, Hope you are all well.
> Strange issue here:
> We have a Custom ABAP program that reads from mainly Table EKKO.
> On My QAS system the program works 100%, when i do a SQL Trace (ST05) i can see in the execution plan that it is using the correct index on the Date field.
>
> On MY Production system the very same program just runs and runs and eventually times out, in the sql Trace the execution plan shows that the index is not being used thus the long run time.
>
> Here is the Catch: the ABAP people have looked at the program intensely and have found no problems, my QAS system is a copy of Pruduction (Syetem copy). Program runs no problem on QAS but times out on Production.
>
> It seems that on Production the Program is not using the Index to search the table.
> Please help
> Regards
> Andre

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language