Monday, November 26, 2018

mySQL Develop Optimization



Select * from MOVPRO where fecmov>='2018-11-25' and tipmov='S'
EXPLAIN Select * from MOVPRO where fecmov>='2018-11-25' and tipmov='S'

CREATE INDEX MOVPRO_fecmov_tipmov_index ON MOVPRO (fecmov,tipmov)


References:
[1] faster using indexes https://blog.nodeswat.com/making-slow-queries-fast-with-composite-indexes-in-mysql-eb452a8d6e46

No comments:

Vectorize PNG to SVG

No Login  [1] https://www.freeconvert.com/png-to-svg   [2] https://svg-converter.com/potrace  Loging required [2] https://www.recraft.ai [3]...