db.l3.ai

Play

lessons

What Changed In 19

Upsert Drills

editor

engine: not started

results

Run a query to see rows here.

check

Pin a plan without touching the query

A stash maps a query id to advice text. With a stash selected, every matching query gets the advice, with no change to the SQL. lab.get_query_id(text) returns the id of a query.

task

Create stash s1, store NESTED_LOOP_PLAIN(c) for the join of orders o and customers c, select the stash, and EXPLAIN the join.

hints