Better index access = worse performance? ?

Better index access = worse performance? ?

Post by Gert van d » Sun, 08 Feb 2004 19:21:04


In article <uF0Vb.42044$ XXXX@XXXXX.COM >, ("PM
\(pm3iinc-nospam\)" <PM(pm3iinc-nospam)@sympatico.ca>) says...


Another trick that changes the search path is to add the 'optimize
for x rows' option.
If the queries are executed from a client it might help to specify
the number of rows which fits in one requester block (DBM CFG -->
RQRIOBLK), although I'm not sure if it still makes any difference.
Most likely it depends on the network speed.