Put in order · NestJS course · Module 3: TypeORM and Databases

Database query optimization

Arrange query optimization techniques from simplest to most advanced:

Items to put in order

  • Adding indexes on frequently filtered columns
  • Using query result caching
  • Table partitioning
  • Using select to fetch only the needed columns

You can check the correct answer by solving this task in the CodeWorlds game.