General information
Title:
Strangeness on SQL Select - help...
Here's the scenario...
I have a table (345,000 records) of transactions. The table has many fields with indexes exclusive to their own fields.
One of the fields is tran_year (transaction year) which has it's own index and is not compounded with any other fields
"INDEX ON TRAN_YEAR TAG TRAN_YEAR"
What I want is the minimum and maximum years from the transaction tables which is simple
select min( tran_year ), max( tran_year );
from transact1 into array laRanges
Here is the problem.
If I am sitting at the command window and run it, no problem, comes back within a split second.
While running the program, the form has a private data session and the table is opened. If I issue this exact same statement, it takes over a minute...
So I tried to suspend the program immediately before this statement to trace any strangeness... but found nothing. I stepped through and again, it took over a minute. Immediately after that, I brought the command window up, changed the datasession to 1 (default), and issued the exact same command there and it took a split second...
Any input on this would be greatly appreciated,
TIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only