Skip to main content
PProfileMatch

Trick Book

Database Indexing

0 of 20 tricks collected.

Collect more on a ride

Database Indexing: How a B-Tree Index Speeds Up Lookups

  • Locked trick - Library basement: shelves of boxes. Ride this lesson to collect it.
  • Locked trick - Row of lockers along the cycle path. Ride this lesson to collect it.
  • Locked trick - Skyscraper lift lobby. Ride this lesson to collect it.
  • Locked trick - Crowded fairground gate. Ride this lesson to collect it.
  • Locked trick - Parking bay that is full. Ride this lesson to collect it.

Ride this lesson

Composite and Covering Indexes: Column Order in Database Indexing

  • Locked trick - Clinic reception desk. Ride this lesson to collect it.
  • Locked trick - Waiting room noticeboard. Ride this lesson to collect it.
  • Locked trick - Ramp up to the bridge. Ride this lesson to collect it.
  • Locked trick - Sorting depot on the ring road. Ride this lesson to collect it.
  • Locked trick - Overloaded cargo trailer. Ride this lesson to collect it.

Ride this lesson

Reading Query Plans in Database Indexing: EXPLAIN in Practice

  • Locked trick - Mechanic's workshop: the diagnostic screen. Ride this lesson to collect it.
  • Locked trick - Test track behind the garage. Ride this lesson to collect it.
  • Locked trick - Junction of two cycle lanes. Ride this lesson to collect it.
  • Locked trick - Road closed: diversion signs. Ride this lesson to collect it.
  • Locked trick - Weather station on the summit. Ride this lesson to collect it.

Ride this lesson

Database Indexing Costs: Write Overhead, Bloat and When Not to Index

  • Locked trick - Warehouse loading dock. Ride this lesson to collect it.
  • Locked trick - Closing-down sale at the bike store. Ride this lesson to collect it.
  • Locked trick - Parcel locker kiosk. Ride this lesson to collect it.
  • Locked trick - Busy telemetry depot. Ride this lesson to collect it.
  • Locked trick - Lost-property office, end of month. Ride this lesson to collect it.

Ride this lesson