Hi all, I have an interesting issue and I was wondering if anyone has seen the same thing.
We have an access database which has an oracle ODBC linked table. It is a large table with ~2.9 million records. A few days ago the table was working fine, opened instantly in Access.
The DBAs have since then added a column and an index to the table. Now the table take ~1 min to open.
I understand that access will take a long time to load all of the data, but I don't understand how it was loading so quickly previously. My guess is that before hand access was loading only a small part of the data initially but now it tries to load all of the data when when the table is opened.
Is that the case? Is there any way to control this? Or are there any rules which say when this happens?
Also, to make things even more confusing, we have a copy of the table in test oracle database. When we link this into access it opens straight away! The DBAs have traced the connection and say that everything should be identical. The test table is actually slightly larger than the live table but the structure is exactly the same.
Any ideas??!
We have an access database which has an oracle ODBC linked table. It is a large table with ~2.9 million records. A few days ago the table was working fine, opened instantly in Access.
The DBAs have since then added a column and an index to the table. Now the table take ~1 min to open.
I understand that access will take a long time to load all of the data, but I don't understand how it was loading so quickly previously. My guess is that before hand access was loading only a small part of the data initially but now it tries to load all of the data when when the table is opened.
Is that the case? Is there any way to control this? Or are there any rules which say when this happens?
Also, to make things even more confusing, we have a copy of the table in test oracle database. When we link this into access it opens straight away! The DBAs have traced the connection and say that everything should be identical. The test table is actually slightly larger than the live table but the structure is exactly the same.
Any ideas??!
