Detailed notes for this lesson are being written. They appear here together with the video.
Video coming soonThis lesson’s video is being made
Start with the notes below; the video appears here as soon as it is on YouTube.
SQL and Databases · Lesson 67 of 90
Query optimisation 2: measuring, hints and bulk loading
slow query logpg_stat_statementsquery profilingbenchmarkingindex hints (USE INDEX, FORCE INDEX)INDEXED BY (SQLite)plan regressionparameter sniffingstale statisticsbatch insertsbulk load (COPY, LOAD DATA INFILE)SQLite PRAGMAs (synchronous, cache_size, mmap_size)query result caching