MS Access SQL - Select to Limit Rows

[jsteeleiii@cox.net]

I am querying ORACLE tables through a fairly slow network connection. While building the tables and testing for data, I do not need all of the records (300,000+). I just need a snapshot of the data so that I can test my field mapping.

I have tried the SELECT TOP ## command, but the performance improvement is negligible. In SQL Server, there are commands to Return ## Rows or Limit the return of rows.

Is there anything I can put in the MS Access SQL window that will allow me to grab just a few rows of data, in any order, as I am primarily concerned with viewing data quickly. I don't want to touch every row in the query, I just need 10 or so rows so that the SQL doesn't have to process every record in all of the linked tables like it would have to in a SELECT TOP statement.

I would like to avoid using the Pass Through as I am building data locally.

Thanks,

 

[namliam]

TOP is not an oracle statement as a result Access is pulling all the records then filtering only once that is done.

Try using a Pass-Through query and using the Oracle RowNum < 10 (or whatever)
Using a linked table has SERIOUS restrictions and complications particularly on performance type issues. In particular with things like this where TOP is not being send into the oracle database, but rather executed on your local machine. Using a Pass-Through you know for sure the SQL is being send to the database and your sure to gain a lot.