Re: Sort time

On Fri, 2002-11-15 at 14:27, Josh Berkus wrote:
> > The big problem is he's sorting by a varchar() which isn't overly quick
> > no matter what locale.  Integers are nice and quick (s.OP is an int,
> > which shows this).
> >
> > If IDS_NUM is a number, he could try casting it to an int8, but without
> > data examples I couldn't say.
>
> Hmmm ... how big *is* that varchar field?  8 characters gives us about 6mb for
> the column.  Of course, if it's a 128-char global unque id, that;s a bit
> larger.

20 characters long in the Unicode locale -- which is 40 bytes?
--
Rod Taylor <rbt@rbt.ca>