Indexes
We have a table with a lot of rows (thousands or millions).
We want to find one of them.
create table twitter_account(
account_id uuid not null primary key,
handle varchar not null, -- Unique
...
);
-- Load millions of rows
select *
from twitter_account
where handle = 'RealReneMagritte';
|