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