Dismal Performance w/ CR8.5 & Oracle 9I via ODBC

[mwake]

I've developed a number of relatively simple list reports using CR8.5 from an Oracle 9I database. The application is called AIM, an HR module. Crystal comes embedded within AIM, and connects to the database via ODBC. The ODBC connection from my machine was configured exactly the same as the AIM config. When I run a list report that contains 2 tables with an equal join and the only select criteria is that a date in table 1 doesn't equal a date in table 2, it takes 15 minutes to run. When the report is refreshed, it takes 5-7 minutes to actually access the database, then you can see the records being counted 1 at a time. This database is a test database, with only 30,000 records and 2 users. When you first log-on and try to expand the database to display the tables, it hangs for a couple of minutes before the table names appear. An ideas as to why this is soooo slow??