Subject Re: ORDER BY on large VARCHAR columns
Author robert_difalco
--- In, Helen Borrie <helebor@t...>
> >has qualified names much like a file system, but they cannot be
> >chopped up and stored hierarchically.
> Why is that so?

Because they would just have to be re-concatenated into a qualified
name and displayed sorted again. I'm pretty sure that would take
even longer. Also, there is a table that joins with each qualified

So there are no tricks of the trade, nothing to do to improve the
sort speed of a large VARCHAR column? Seems like I am pretty
consistently hearing "Doctor it hurts when I do that" -- "Don't do
that". ;) I sure wish I could just create an index on it, regardless
of the size.