Re: [SQL] Replacing a simple nested query?

[Joe Conway]

Steve Wampler wrote:
I've got a simple nested query:

  select * from attributes where id in (select id from
     attributes where (name='obsid') and (value='oid00066'));
that performs abysmally.  I've heard this described as the
'classic WHERE IN' problem.
I may be missing something, but why can't you just do:
  select * from attributes where name='obsid' and value='oid00066';
?
Joe

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])