Hi Carmen,

I think the "10 latest record" and "SQL" is the key here. As far as I know, when you use SQL to display the TOP XXX records the query will return ALL matching records and then display the TOP XXX. If there are a lot of records matching the item code then it will longer to extract these records than just 10. You may want to try building an index on the item code + ttoc(datetime(), 2)
and scanning the next 10.

HTH

Liam


>I have about 30 thousand transaction in the table called trn. When I entered item code, Press F9 then 10 latest record will be showing out in the grid. I am using Local View to retrieve. It is very slow, It used about 2 minit to display in the grid. I try to use SQL to retrieve, It also very slow...
>Any Other method \ procedure to do faster then this.............