Cesar,
You need to build the index also, try BUILD.INDEX FILNAME ALL
In Unidata that is.
Björn Eklund
-Ursprungligt meddelande-
Från: Cesar Riba [mailto:[EMAIL PROTECTED]
Skickat: den 19 februari 2004 17:24
Till: 'U2 Users Discussion List'
Ämne: RE: [UV] Very slow SQL query
-Mensaje
César,
So the problem is not joins or indices. So it must be somewhere else :-)
1. If you use a SORT command, is that as slow?
SORT CCMLIAL BY EMP BY ALBA BY NUMLIN WITH EMPABLA = 1*05236 PEDIDO REFART
DESART CANDIDAD CANTMODALB NOPAGE
2. If it is, what are these fields doing? Are they Data