SQL for pagination queries - advanced options
Advanced extensions for writing SQL when doing pagination style queries against the database. In this video you'll learn:
indexing options
result caching
blog: https://connor-mcdonald.com
twitter: / connor_mc_d
Subscribe for new tech videos every week
All other social media channels here: https://linktr.ee/connor
My current favorite Oracle stuff:
Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages.
https://docs.oracle.com/en/database/o...
Favorite 18c feature: Killing a runaway SQL without killing the entire session.
https://docs.oracle.com/en/database/o...
Favorite 19c feature: Handling JSON just got a lot easier!
https://docs.oracle.com/en/database/o...
Music: Night Owl (Broke For Free)
#pagination #sql #performance