Skip to content

Instantly share code, notes, and snippets.

@matt212

matt212/gist:4094152be78ed2604313badff5ab115c

Created July 22, 2022 18:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matt212/4094152be78ed2604313badff5ab115c to your computer and use it in GitHub Desktop.
Save matt212/4094152be78ed2604313badff5ab115c to your computer and use it in GitHub Desktop.
Download ZIP
Sample search and group clause
Raw
gistfile1.txt
File Refer https://drive.google.com/file/d/1fgEqB4LrSYhhgyeoKZl32ab-yO__bDht/view?usp=sharing
I would to optimized below query
select a.gender from "employees" as a
where lower( gender ) LIKE 'f%' group by gender
limit 20
query execution plan
https://explain.dalibo.com/plan/h7e
Please use gdrive link to download and restore the sql to database for above query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment