Home » RDBMS Server » Performance Tuning » Do Remote Table use Remote indexes ?
Do Remote Table use Remote indexes ? [message #65723] Wed, 15 December 2004 03:36 Go to next message
Gerald
Messages: 54
Registered: January 2001
Member
Dears,

I'm tunning an SQL query like

Select (...) FROM owner.table1@remotebase TAB1

and I want to HINT with index_combine,

Select /*+ index_combine (tab1) (...) FROM owner.table1@remotebase TAB1

my question is would it use remote indexes ?

or should i put something like that?

Select /*+ index( tab1 Owner.tab1_index01@remotebase Owner.tab1_index02@remotebase Owner.tab1_index03@remotebase) (...)/* FROM owner.table1@remotebase TAB1

 

 

 
Re: Do Remote Table use Remote indexes ? [message #65727 is a reply to message #65723] Wed, 15 December 2004 22:03 Go to previous messageGo to next message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
Select /*+ index_combine (tab1) (...) FROM owner.table1@remotebase TAB1........is the right one
Re: Do Remote Table use Remote indexes ? [message #65782 is a reply to message #65723] Thu, 23 December 2004 03:16 Go to previous message
Milind Deshpande
Messages: 93
Registered: May 2004
Member
Hi,

Try /*+DRVING_SITE(
)*/ hint on the remote table in the query. This might help.

Regards

Milind.
Previous Topic: FROM and WHERE clause
Next Topic: Improving a "DISTINCT" query on a column with skewed data
Goto Forum:
  


Current Time: Thu Mar 28 06:10:36 CDT 2024