how many records are returned ? Arnon >like >Select * ; > from mytable; > where upper(myfield) > [SOMETHING]; >into cursor >then it going like turtle ;( (about 80-90 sec). I sure that this table >have index Upper(myfield) and then this query should be fully optimizable, >but SYS(3054,11) tell me info that this query is partially optimizable. I >can't figure out what's wrong. No matter that myfield is character, the >same happens with numeric field > >Have a happy day >Vladimir Shevchenko > >> In the INIT method of the grid, issue a select statement with your >filter > >> as the WHERE clause. If the WHERE clause is based on Indexed fields, >this > >> is very fast. Base the control source of the grid to the cursor and you >> will get blazing performance. > >