SELECT t3.transaction_pci_details_id, t3.terminal_id, t3.transaction_no, t4.transaction_id, t3.transaction_type, t3.reversal_flag, t3.transmission_date_time, t4.retrivel_ref_no, t3.card_no, ...
I have problem with two queries on PostgreSQL v8.2. It seem like the optimizer chooses a wrong index: db=# explain select count(*), messagetype, alias from event where templateinfoid = 10 and ...
We are using Oracle 11g, 22.214.171.124. We know a record exists in a table but a select is not returning it for some odd reason. The execution plans the general query, not forcing any index, shows that ...