issue summary
- I need to use my client table to lookup name, address, etc
- my client table has 2 million rows, but only 167,000 unique clients, so I need to find the most current "max" entry for each
- most current entry is easy to find using a group by with max that gives me the "PK" for the rows I want ("PK" is max date & ID)
- I concatenate date || ID and use an IN to make sure I get the correct row from my subquery
- this runs slow since I have 167,000 values for my IN statement
issue screen print
oracle version session Metadata (getDatabaseProductVersion): Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options