Mensaje
De
20/12/2006 12:58:05
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregón, United States
 
General information
Foro:
Visual FoxPro
Category:
Problemas
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
ID de la conversación:
01178661
ID del mensaje:
01179282
Views:
12
Perhaps you might give me guidance on this one question. It is:

Specifically what, other than 1) tags, 2) keys, and 3) collation sequence, are documented factors in revealed SYS(3054) showplans' differences?

We are still unsuccessful in solving this issue.
1) LIST STATUS indicates that, in both instances, all of the tags and their collation sequences are identical.
2) Both .DBCs, "development" and copy of "production" data, are on the same server.
3) Both have close to the same number of records.
4) The SELECT - SQL expression ran adequately for years and is unchanged.
5) The "development" data completes in approximately 0.015 seconds 
   (as did the production data until last week).
6) The "production" data completes in approximately 23.6 seconds
Thank you for all of the kind help you have given.

Spencer
Previous
Next
Responder
Mapa
Ver