Ken Cooper wrote:

SELECT id, . FROM additionalchunks WHERE id=? OR id=? OR .


or

SELECT id, . FROM additionalchunks WHERE id in (? ? ? ? ? .)

Which of these is the more efficient...

The second, assuming you have an index on additionalchunks.id. Without an index, they are about the same.


-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565



Reply via email to