>>Is this performance problem related to SELECT-SQL only or to regular table opening/skipping/using as RowSource too?
>
>No, it's overall. Doing a simple BROWSER over 100000+ records will take up to 20 seconds to appear if you have SET DELETE ON.
But how let's say we can use Table Alias as RowSource if SET DELETED OFF? Abstaining from SET DELETED ON means that all comboboxes/grids and so on shouldn't be filled from tables/fields.
Edward Pikman
Independent Consultant