|
Home > Archive > MS SQL Server > July 2005 > Fastest way to query Oracle
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Fastest way to query Oracle
|
|
|
| I have linked my Oracle9i database to SqlServer2000. When I query the Oracle
database
from Query Analyzer it is taking much longer time than if I do it from
Oracle directly.
Is there anything I can do make my queries run faster?
| |
| Narayana Vyas Kondreddi 2005-07-21, 7:23 am |
| Just a quick thought. See if you use OPENQUERY to make the query faster. See
SQL Server Books Online for more information and examples.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"ln54" <ln54@discussions.microsoft.com> wrote in message
news:8AFAE7AE-BD27-43E7-B1E7- 1B20600E44AE@microso
ft.com...
I have linked my Oracle9i database to SqlServer2000. When I query the Oracle
database
from Query Analyzer it is taking much longer time than if I do it from
Oracle directly.
Is there anything I can do make my queries run faster?
| |
|
| ThankYou, this was much better,
also thanks for Your excellent script "searchalltables"
"Narayana Vyas Kondreddi" wrote:
> Just a quick thought. See if you use OPENQUERY to make the query faster. See
> SQL Server Books Online for more information and examples.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
> "ln54" <ln54@discussions.microsoft.com> wrote in message
> news:8AFAE7AE-BD27-43E7-B1E7- 1B20600E44AE@microso
ft.com...
> I have linked my Oracle9i database to SqlServer2000. When I query the Oracle
> database
> from Query Analyzer it is taking much longer time than if I do it from
> Oracle directly.
>
> Is there anything I can do make my queries run faster?
>
>
>
|
|
|
|
|