| Subject | RE: [Firebird-general] On the CA Ingres community page there is an interesting discussion thread ... |
|---|---|
| Author | Claudio Valderrama C. |
| Post date | 2005-05-14T01:27:41Z |
Firebird-general@yahoogroups.com wrote:
The funny part is:
BEGIN QUOTE
Jocelyn,
One thing that I have noticed is the syntax of your queries. In my
experience the use of the 'join' syntax is to be avoided as it prevents
Ingres executing the query in the most efficient way. Try replacing the join
with a , (comma) and place the conditions in the where clause.
It may help.
regards,
Dave Stephens
END QUOTE
We recommend exactly the opposite: to use JOIN instead of the old pre-SQL92
syntax.
C.
>http://opensource.ca.com/projects/ingres/forum/10/650886925835?b_start:int=0
The funny part is:
BEGIN QUOTE
Jocelyn,
One thing that I have noticed is the syntax of your queries. In my
experience the use of the 'join' syntax is to be avoided as it prevents
Ingres executing the query in the most efficient way. Try replacing the join
with a , (comma) and place the conditions in the where clause.
It may help.
regards,
Dave Stephens
END QUOTE
We recommend exactly the opposite: to use JOIN instead of the old pre-SQL92
syntax.
C.