SQL CREATE INDEX
The following command will create an index named tenant_id_idx on the id column of the tenant table.
-- Works in PostgreSQL, MySQL, SQL Server, and Oracle.
CREATE INDEX
tenant_id_idx
ON
tenant(id);