Good Day to you guys, I have a db that contains about 33 million records per table (4 tables).when i execute the following queries it takes to much time to retrieve about 5 miniutes per query.
1- select "Records"."Operation", "Records"."status", "Records"."timestamp" from "History" where "Records"."timestamp"=(SELECT MAX("Records"."timestamp") FROM "History" where "rowId" like ?)
can you help me adjust the performance? --- Ahmed
