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.
- Jayesh