General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only