SyntaxPilot
Courses/SQL and Databases/Lesson 67
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

Detailed notes for this lesson are being written. They appear here together with the video.