LTX makes no sense
Can anyone answer this puzzle, which tech support
agrees is "bazaar" (yes, the products were
installed correctly, tools, then ONLINE 5.02 UC6 then
ISTAR):
Why the long transaction, error -458?
When:
the database does not have logging
no updates (ie: changes to data) are involved
set explain mentions no temp tables/files.
The select that causes the -458 is:
select c1,c2 from a
where not exists
(select * from b where a.c1 = b.c1)
What is being logged and why?
Thanks for any insight.
------------------------------------------------------
Jean Van Loan Colo. Div. Water Resources
jvl@dbserver.dwr.co.gov 1313 Sherman St. Rm. 821
Denver, CO 80203
Ph. 303-866-3585 ext.258 Fax: 303-866-3589