I had created a SQL statement that I could have swore was optimized. Now (months later), the statement is slow as dirt and is showing that it is no longer optimized.

The index expression is TTOC(tCreated,1) and my select has WHERE BETWEEN(TTOC(tCreated,1), lcStart, lcEnd). The lcStart are user defined dates that have been properly converted with TTOC(,1).

If I remove the TTOC, the query is fully optimized but this is currently not the best answer.

The table usually has around 500,000-800,000 records and will take 45 minutes not optimized but about 30 seconds optimized.

Is there something wrong in my Select? Why will this not optimize anymore?

Thanks in advance for the assistance.

Todd