Re: File Join question

["Jay Himes" <j@xxxxxxxxxxx>]

<snip>

> But I think the SQL philosophy is that the index is separate from the
> view.  The view is just to select certain rows and/or columns and the sql
> optimizer will pick the best index to perform the job, saving you that
> effort.

The problem that I have had (interestingly I have experienced this on MS SQL
server too) is that the optimizer does not seem to use the  indexes when
running a select from a view.

Thus:
 select * from TheView;
  is almost always slower than
 select * from (TheViewCode) as tbla;
if you have defined appropriate indexes.
If you have not specified indexes they are approximately the same.