Hi,
Becker wrote-->
>With version 7.4 your wish became true and if I find some time
>I'll integrate this feature into version 7.3.
Good and that 7.3 integration will be very useful whenever it happens.
When is 7.4 final expected?
>I suppose ORACLE updates a row counter for every insert and delete.
>But I'm not sure because this could let into concurrency problems.
>I'm appreciate for every hint on this topic.
I'll try to see if I can run some explains in oracle to determine what happens.
However I don't think it's a row counter. Bcos even if you
select count (SomeNullableColumnWithNoIndex) from sometable
it runs extremely fast in oracle(<1sec).(and will usually give a different result than
select count(*) for obvious reasons)
Anyway I'll try and determine how oracle/postgreSQL do it and get back to you.
Regards,
Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general