Session 3 - It's 11 pm, Do you know where your queries are? - Part 2

Managing Indexes

• used for making data quickly able to be looked up
• they should be present on everything you will search for
• usually only put on primary keys
• if not indexed, result will be a gradual slowdown (as there is more data)
• single column index and multicolumn indexing is possible

Lazy Loading

• don't grab everything if you don't need it, (large pictures can be pulled and not used but take up processing time for instance)
• basically not selecting *, select first_name, last_name for instance