--- In firebird-support@yahoogroups.com, 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
name.

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.