If the field in question is limited to numeric values, it should be defined using a numeric type in the database (else sort order will not work correctly).
Regardless, if you are filtering a varchar field using numeric types, JDBC will convert the values used for filtering which will surely effect performance somewhat.
To investigate all of this you could make use of the trace debugging capabilities, which will allow you to view the exact SQL statement used by Tersus - if you locate the Find/Advanced Find in the trace, and expand you'll be able to view the statement (and right-click -> Copy it).
Regards,
David
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign
