Re: Fw: Are level checks still useful?

[Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>]

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.