How to optimize SQL ?
Use of minimal columns in table creation. (max 100 columns).
Avoid use of distinct; use ‘group by’ instead.
Use of LIMIT when fetching records.
Avoid use of * in the select statement. Define columns instead.
Indexing tables. Try using composite...
bikash8848.hashnode.dev1 min read