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