Ayyappan  M

Ayyappan M

  • NA
  • 1
  • 1.2k

Help on SQL query

Nov 30 2011 9:12 AM
Hi,
Can you let me know, which of the following query execution gives better performance.

Also, the table T1 is not indexed and the table can have 100,000 records.

Case 1:
DELETE FROM T1 where NAME = 'Ayyappan'
DELETE FROM T1 where NAME = 'Manivel'

Case2:
DELETE FROM T1 where NAME in ('Ayyappan', 'Manivel')






Answers (4)