Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> performance: index on foreign (primary) key ???

performance: index on foreign (primary) key ???

From: Michael Keppler <Michael.Keppler_at_bigfoot.com>
Date: Sat, 18 Sep 1999 13:19:50 +0200
Message-ID: <7rvs25$824@TGZ3> 





Hello everybody !



I have a column that always references the primary key in another table
as foreign key. Now I do a query on that column in the first table. Can
I speed up this query by creating an index for the column in the first
table or will the optimizer use the (primary) index of the second table
for this ??



Ciao and Good Bye, Michael.



--


Michael Keppler, MCSE, MCP+I


IT logic GbR


Michael.Keppler_at_gmx.de


Received on Sat Sep 18 1999 - 06:19:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US