Re: Indexes ignored

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 13 Jul 2002 15:54:22 +0100
Message-ID: <3d303f21$0$8513$cc9e4d1f@news.dial.pipex.com>

"Michael Austin" <maustin_at_firstdbasource.com> wrote in message news:3D3023CB.B1CDF982_at_firstdbasource.com...

> Just a nit, but why would anyone use a varchar field for a field that
> will only contain numbers? I can't think of anyplace that uses BR549
> any more... :) << that should date some people :)

I don't get you reference but we use the equivalent. The administrators and operators of the application like BR0101 to refer to the audit of bramley council (client br01) in the year 2001. Me i think of them as meaningful,meaningless sequences but hey what do i know.

Oh and our staff numbers are stored in character fields! and aren't necessarily unique.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Sat Jul 13 2002 - 09:54:22 CDT