On 6/29/07, Andrew Finkenstadt <[EMAIL PROTECTED]> wrote:
On 6/29/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote:
>
>
> You can do it with a JOIN instead of IN and I'm pretty sure it will
> still
> use an index.
>
>
> SELECT
> COUNT(*)
> FROM
> guid_version_map M
>
On 6/29/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote:
You can do it with a JOIN instead of IN and I'm pretty sure it will still
use an index.
SELECT
COUNT(*)
FROM
guid_version_map M
LEFT JOIN
latest_version V
ON
You can do it with a JOIN instead of IN and I'm pretty sure it will still
use an index.
SELECT
COUNT(*)
FROM
guid_version_map M
LEFT JOIN
latest_version V
ON
M.guid = V.guid AND M.version = V.version
WHERE
3 matches
Mail list logo
