Rushmore (indexes kicking in) will happen only on an exact match
of the index expression. The answer would be yes - seperate indexes
would help.

Also try optimizing the code with the SYS(3054,11) [Rushmore Optimization Level] function.

>The following is the Select statement for a view :
>
>SELECT Ptinvent.brand, Ptinvent.partno, Ptinvent.descrip,;
> Ptinvent.rating, Ptinvent.utqg, Ptinvent.price1, Ptinvent.onhand,;
> Ptinvent.committed, Ptinvent.milwar, Ptinvent.saprice,;
> Ptinvent.warehouse, Ptinvent.cost, ; Ptinvent.taxind,Ptinvent.acctrevn,;
> Ptinvent.acctrevnt, Ptinvent.acctcogs, Ptinvent.acctinvt,;
> Ptinvent.groupcd, Ptinvent.reqreas, Ptinvent.olform, Ptinvent.pcom,;
> Ptinvent.fet, Ptinvent.price2, Ptinvent.price3, Ptinvent.wpartno;
> FROM vitdata!ptinvent;
> WHERE Ptinvent.twidth = ?vWidth;
> AND Ptinvent.tratio = ?vRatio;
> AND Ptinvent.rim = ?vRim;
> ORDER BY Ptinvent.warehouse
>
>The table ( ptinvent ), currently has an index ( twidth + tratio + rim )
>
>Sample code :
>
>vWidth = '205'
>vRatio = '65'
>vRim = '15'
>requery('vwViewName')
>
>Would I get better performance with seperate indexes on each of the three fields in the ptinvent table ?
>
>Can the view statement be changed for better performance after the WHERE
>Ex: WHERE ( Ptinvent.twidth + Ptinvent.tratio + Ptinvent.rim ) = ;
> ?vParameter
>
>vParameter = '205' + '65' + '15'
>requery('vwViewName')
>
>Thanks !! CB