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?
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@.microsoft.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@.microsoft.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?
>
>