Fastest way to check if a record exists
mail8mzNov 20 2012 — edited Nov 21 2012Hi,
I have a table with more than 100M records. What is the fastest way to check if a record exists or not. Currently, I am using Oracle 11.2. The following is the SQL I used, id is the primary key of the table_test.
select count(*) into existFlag
from table_test
where id = testID
;