What could be the reason that select queries performed inside a transaction is really slow even though the queries are with just their primary key?
I have two tables after updating one row in table1 the query in table2 within the same transaction is really slow even though the query on table2 is just
select * from table2 where id = 10
table1 and table2 have a lot of rows