Subject | Re: Order of execution of SQL statements in FB |
---|---|
Author | Tom Conlon |
Post date | 2007-02-01T19:01:58Z |
Hi Svein,
not specific to Coldfusion but applied to DB server software generally.
I was interested to know if there was a pre-defined standard somewhere
of the execution order for SQL engines (one would have thought so)
and, if not, then whether there was variations between the
implementations.
e.g.
Do most database software extract the conditional part of joins (if
present) and add them to the WHERE clause or do some execute them
*prior* to the evaluation of the actual WHERE clause.
Hope this makes sense,
Tom
> I seriously doubt Firebird is anything like ColdFusion in this area,My interpretation of the Celko book (plus the link) is that this was
not specific to Coldfusion but applied to DB server software generally.
I was interested to know if there was a pre-defined standard somewhere
of the execution order for SQL engines (one would have thought so)
and, if not, then whether there was variations between the
implementations.
e.g.
Do most database software extract the conditional part of joins (if
present) and add them to the WHERE clause or do some execute them
*prior* to the evaluation of the actual WHERE clause.
Hope this makes sense,
Tom