That's what I'm thinking....build the statement (dynamic). It seems I
would have a lot of indexes - 10 based on the 'between' criteria.
This selection logic is used a lot - for subfile load on a green
screen and for exposing a result set to PHP. If I was to make this
dynamic (which I believe means creating the SQL statement by building
a string and executing it), would I have issues because the access
plan will be rebuilt every execution of the program?
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact