Search

Top 60 Oracle Blogs

Recent comments

boolean

(this is an answer to Jeff Potter —  “3 Reasons I Hate Booleans In Databases”)

(this is an answer to Jeff Potter — “3 Reasons I Hate Booleans In Databases”)

I’ll start with the “benchmark” because I like facts.

Testcase

Here is your test which I ran on less number of rows (because it is not needed and easier to run and share from db<>fiddle) and I’ve run the queries once before in order to warm-up the cache. And I displayed the execution plan to get better understanding about the response time: