CREATE TABLESPACE ts_data IN dbs1; CREATE TABLESPACE ts_index IN dbs2; CREATE INDEX idx_customer ON customers (customer_id); SELECT * FROM customers WHERE customer_id = 123; SET LOCK MODE TO WAIT; SET ISOLATION TO COMMITTED READ;