I am accessing two tables from a database that resides on a server different from the server I am working on.
When I run a simple select * query on these tables, Table A takes about 9 sec to return the data(9500 rows, 10 columns) the Table B takes over 2 1/2 minutes(140000 rows, 13 columns). I have to JOIN these two table, Table A has two Primary Keys and Table B has no keys defined, when I Join these two tables on the condition where the two Primary keys on Table A match the columns of same type on table B it takes over 5 minutes for the query to return the data.
Can the simple select queries be optimized for time performance?
I also ran the queries logging into the server but got the same time results!