Re: What is the fastest query to check for an existence of a row

Thank you Kristian. That is exactly what I found as well but was waiting for the email to show up so I could reply to my own. Wow what a difference that made! I keep scouring the documentation and find some new nugget each time. Thank you very much for taking the time to reply and confirm

Re: What is the fastest query to check for an existence of a row

Den 25.05.2016 23.12, skrev Bergquist, Brett: > I have a table with 80,640,704 rows. My query currently is: > > > > SELECT > > COUNT(*) AS USE_COUNT > > FROM > PKG_9145E_V1.COSEDDROPPROFILEDSCPTABLEBUNDLE_COSEDDROPPROFILEDSCPTABLEENTRY > CBCE > > WHERE

What is the fastest query to check for an existence of a row

I have a table with 80,640,704 rows. My query currently is: SELECT COUNT(*) AS USE_COUNT FROM PKG_9145E_V1.COSEDDROPPROFILEDSCPTABLEBUNDLE_COSEDDROPPROFILEDSCPTABLEENTRY CBCE WHERE CBCE.COSEDDROPPROFILEDSCPTABLEENTRY_ID = 768 AND CBCE.COSEDDROPPROFILEDSCPTABLEBUNDLE_ID != 2 This query is