We are using Oracle 11g, 126.96.36.199. 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 ...
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 ...
I have this fairly straight-forward snippet of a query: DECLARE @ClientGUID numeric(16) = 9000011916900200; SELECT ch.GUID, c.LastName, c.FirstName, mrn.ClientIDCode AS MRN FROM Client c INNER ...