query optimization delete nested query

Question

Can the following query be optimized ?

DELETE FROM COLOR_TAGS 
WHERE COLOR_PROJECTID = $id 
AND NoteID IN(
SELECT ID FROM note_note 
WHERE BibID=$bid AND isdel=0);

Is it suboptimal? If yes, how? Please, make your questions a bit more meaningful by adding detail. If you don't provide us with details, the best answer is 'Probably yes/no'. Until then, I place a -1 vote.
possible duplicate of query optimization for update nested query IN(SELECT

Andriy M · Answer 1 · 2012-09-15 23:59:34Z

up vote 4 down vote

Add composite indexes to your tables:

On COLOR_TAGS, index (COLOR_PROJECTID, NoteID)

On note_note, index (isdel, BibID, ID).

edited Sep 15 at 23:59

Andriy M
3877

answered Sep 14 at 10:58

Rob Farley
2,4161211

feedback

1 Answer