Re: less than, index and string

tmp123, how are the strings to be compared? That is, the character values '123' compares as less than '14' while the numeric value of 14 is less than 123.

Based on the answer you should probably either choose varchar2 or number(10,0) as your datatypes.

With only a three column row where two of the three values are used in the search condition (where clause) I would consider using an IOT to house the data. The PK being cmin and cmax.

HTH -- Mark D Powell -- Received on Tue Feb 14 2006 - 09:02:58 CST