Is it possible to perform a dynamic SQL join?

ASP.NET, SQL & Oracle help is needed?

• Good day, please advise on the best practises for the following scenario: Description: 1)I have an SQL-Server table with over 1,000,000 records 2)and an Oracle table (also with over 1,000,000 records) on another server 3)I have an ASP.NET application that will receive a GET parameter, perform a join sql query on the field between the two tables described above to generate a PDF file based on the results. Limitations: 1)I have no control to perform major operations like moving one of the tables to reside with the other on the same database. 2)I only have read privileges on the database, so I cannot create a temp table to hold the records of the other table. Notes: I have used an ASP.NET dataset to hold the two tables and performed the join with the relation class but still the operation is too slow and impractical. What do you suggest? & thanks in advance.

• Answer:

  Make sure you aren't selected the entire table in both cases, when is not necessary. selecting only rows, and ranges of them will speed up your database queries. If applicable, implement 'pages' into whatever you are using the information for, only selecting and displaying X results per 'page'.