Re: Searching across three files

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

On Thu, Oct 23, 2008 at 2:02 PM, James Lampert <jamesl@xxxxxxxxxxxxxxxxx> wrote:
> One thing: how would I index this, for better performance if the user is
> doing the look-up by part-number? Unfortunately, while I vaguely
> remember SQL indexing from a class I took in Rochester, neither my
> memory nor my copy of "SQL for Dummies" have a whole lot to say on the
> subject.

You can't.

Best you can do is have an index over part-number for each of the
three physical tables.

The query engine will use those individual indexes when you query the view.

Charles