Re: Table join expertise needed badly

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sat, 15 Apr 2006 18:19:43 -0400
Message-ID: <faidnYI7ZOIe7NzZnZ2dnUVZ_sKdnZ2d@comcast.com>

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1145138151.413347.103050_at_j33g2000cwa.googlegroups.com...
: Mark gave good advice. I will add some more. Look at the facts
: available as where clause conditions and look to see which tables these
: facts give you access to. The idea being to look for an entry point
: into the data that will provide the most up front filtering of rows.
:
: HTH -- Mark D Powell --
:

mark,

i'd think that may provide some idea on what to index, if indexing selectively, but i'm not sure if that would affect the join clauses

can you eleborate?

++ mcs Received on Sat Apr 15 2006 - 17:19:43 CDT