Re: indexes and database links

John H. Yates wrote in message <6fbmlf$5p3$1_at_netnews.upenn.edu>...
>A DBA from the remote site says:
>"When you are accessing a table accross a database link, you do not have
>access to the remote database's data dictionary. Effectively you cannot
>use any of the indexes on the remote machine."
>Is there a privilege required that they haven't given us to be able to
>use the indexes? I find it difficult to believe this would be the default
>for searching Oracle databases. If you have access to the database table
>itself, you should have access to its indexes, no?
>

I don't think this is true. It's like saying that SQL*Plus does not have access to the database data dictionary and therefore can not use indexes. It's not up to the client to parse and create an exec plan for a SQL statement. I would think that the same applies to a database link. Whether or not your working from a server is not relevant, as that server is making a -client- connection to another server. That remote server -does not- care whether the piece of software on the client side is Excel, VB, SQL*Plus or another Oracle Server - it views that "thing" on the other end of the connection as a client. Period. The remote server will parse and exec plan for that SQL and it will run the SQL statement. And if it want to use indexes, then it will.

regards,
Billy Received on Thu Mar 26 1998 - 00:00:00 CST