Hi Jim,

Yes, I am opening the view with NODATA.

I only have a handful of deleted records and NO I do not have a tag on DELETED().

If I add the index as expression = TTOC(xxx,1) or DTOS() would I not need to make the same changes to the where clause, or does it matter?

TTOC(Account_debits.dtxndatetm,1) >= ttoc(DATETIME()-432000,1);

Do the index expr and the use of it in the view not have to be in sync with each other for optimization? That is probably the part I do not "get".

Thanks,
John