Subject Re: ORDER BY on large VARCHAR columns
Author robert_difalco
--- In, "Ann W. Harrison"
<aharrison@i...> wrote:
> OK, that's easy. Create three (or N) other fields, populate them
> with triggers that chop the main field into three (or N) pieces
> and index the pieces. Your queries will be
> select whole_field from table order by sub1, sub2, sub3

Excellent, I'll try that today.