## Metadata - Author: [[bytebytego|Bytebytego]] - Full Title:: Secret to Optimizing SQL Queries - Understand the SQL Execution Order - Category:: #🗞️Articles - Document Tags:: [[sql|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](https://read.readwise.io/read/01h0m6z7ajme7qq4gh00xqraka)) > 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](https://read.readwise.io/read/01h0m71ame06q0ehe50vrbx25e))