So I have access to this DB2 table. I used Access to link to the table. When I open the table is takes a long time for it to open because of how many entry's are in this table(i'm assuming).
How can I get this to run faster?
What I really want to do with this table is setup a query to only return quarters of each year I specify. So for example I needed to run a query last night on quarter 4 of 2013.
What I ended up doing was I built a query to view the table and tryied to filter the results based on a column. That was a mistake, when I clicked on the header in Access to the column I wanted to filter and selected a date to filter by it ended up locking up after 15 minutes. It just sat there greyed out running the query. Lots of records in this table.
Thanks in advance,
Tom