Hello Michael,

This is a standard behaviour of SQLs. Find some alternative to it.

:) If you find something, Please let me know.

Bye
Jayesh

>Is there a way to run a SQL statement on buffered data that has not been committed on an optimistic table buffering with multi-locks on? The SQL is retrieving the original data from disk which is cool in some cases. In the past I've issued the 'COPY TO' then executed a select statement on the copy. Any suggestions would be appreciated.