Re: Fw: Are level checks still useful?

Hi, Alan:

My explanation was intended as a "conceptual" one, for illustration purposes, to help aid understanding, at a basic level, of the primary differences between SQL access and Record Level Access (RLA).

Of course, the actual implementation details might be somewhat "optimized" ...

Thanks for the clarifications of some of the finer points.

Mark

> On 11/1/2012 7:57 PM, Alan Campin wrote:

I would agree with what you are saying except the part about the system
dynamically determine the position every time. I believe only occurs when
the access plan is recalculated which only occurs if the table has changed
or some statistic like the number of records in the table has increased by
some amount.

Now if you were doing this from a PC it would occur when you did the
PREPARE and would not occur again in that session. If you always used
EXECUTE IMMEDIATE it would be every time (People acactually do that).

I, slso, don't believe there is anything at runtime that checks to see if
the data fits. It is a strict move and if it doesn't fit it blows up. The
compiler may or may not check.