Hi Sergey,
I splited this query by two (first CMRView and SiteMstr, index this result on SiteMstr, then result with TranMstr) and the speed now is improved considerably.
Thanks.
>Hi Nadya,
>In cases like that I usually try to split the query into multiple steps
>First, I would run query like follows and see how much faster it gets
>
SELECT TranMstr.PropID, oJC.CurState as State, Date, Mortgage, Source, ;
>ParentCode as Lender, extrWeek, extrYear ;
>FROM TranMstr ;
>where between date ctod('01/01/2001')and ctod('06/30/2001') and between Mortgage 1 and ,1000000000 INTO CURSOR Step01
>
>If it really speads up things than I'would join the rest of tables with this cursor or try some other combinations.
If it's not broken, fix it until it is.
My Blog