>This view is currently taking about 2.5 minutes to load.
>Can anyone help me speed up this select/view?
>It's composed of 3 tables:
> Orders (9851 reocrds)
> OrderItems (31385 records)
> Supplier (10 records)
>
>The result table/view should end up with 31385 records
>
>Orders has an index on Order_id
>OrderItems has an index on Order_id and an index on Sup_id
>Supplier has an index on Sup_id
Richard, in my experience, Rushmore does a poor job of optimizing joins between 3 or more tables.
Try using a SELECT on Orders and OrderItems only with a function reference to get the supplier code id. The function should do a seek on Supplier.Sup_Id and return Supplier.Code.
If you try this, I would love to know if it helped.
Peter
Peter Robinson ** Rodes Design ** Virginia