Antaresdatabase -

“It’s frozen,” Maya whispered. “I tried a SELECT * on the entire star_motions table — 400 million rows. I didn’t mean to, but I forgot the WHERE clause.”

It returned in 0.2 seconds.

With the indexes added, the query rewritten ( SELECT magnitude FROM star_motions WHERE star_id = 'Antares' AND timestamp > NOW() - INTERVAL 7 DAY ), and partitions in place, Maya ran the query again. antaresdatabase

Maya’s senior colleague, Leo, walked over. “What’s the status of Antares?” “It’s frozen,” Maya whispered

Leo smiled gently. “Ah. A classic. AntaresDatabase is powerful, but it needs guidance. Let’s walk through three friendly rules.” With the indexes added, the query rewritten (

Leo showed Maya the EXPLAIN command. “See here — a full table scan. Antares is screaming for help. Preview your plan before you query.”