POV-Ray : Newsgroups : povray.off-topic : Question for SQLers out there : Re: Question for SQLers out there Server Time
11 Oct 2024 03:15:28 EDT (-0400)
  Re: Question for SQLers out there  
From: Invisible
Date: 12 Feb 2008 11:42:59
Message: <47b1cc93$1@news.povray.org>
Tom Austin wrote:

> Should a JOIN be used here?
> Does it matter?

As I understand it, on any half-decent DB engine there shouldn't be any 
performance difference. (The two are equivilent under the relational 
algebra.) As for readability... well that's a whole other matter. You 
might well argue that using the JOIN keyword makes the intent clearer.

It's a while since I've looked at this stuff seriously.

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*


Post a reply to this message

Copyright 2003-2023 Persistence of Vision Raytracer Pty. Ltd.