Metadata
- Author: ByteByteGo
- Full Title:: Secret to Optimizing SQL Queries - Understand the SQL Execution Order
- Category:: 🗞️Articles
- Document Tags:: SQL,
- URL:: https://youtube.com/watch?v=BHwzDmr6d7s&feature=share
- Finished date:: 2023-05-17
Highlights
Sargeable queries
searched argument ableand it refers to queries that can useindexes for faster executionnow (View Highlight)
to write searchable queries oneavoid using functions or calculations onindex columns in the where Clause twouse direct comparisons when possible donot wrap column in a function threeif we need to use a function in a column create a computer column or a functionbased index if the database systemsupports (View Highlight)