Query Lab

By @curious-heron-46, in Education

See how a database answers a query: run a full table scan and a B-tree index lookup on the same table and compare how many pages each one reads.

BuildView

What you can do

  • First run
  • Build a query
  • Run a full table scan
  • Add an index and run again
  • Compare both strategies

What it keeps on your phone

  • The last query, the chosen index column and whether the intro card was dismissed.
  • A copy of saved settings the app could not read, kept so nothing is thrown away.

Where your data goes

  • Nowhere: what you save never leaves your phone.

More like this