Re: Querying a number column.

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 24 Jan 2003 00:56:13 -0500
Message-ID: <v31lc18l97j078@corp.supernews.com>

why would the index be ignored?
I don't think so. Though I agree about the type conversion.

Anurag

"tojo" <Tojo_at_hotmail.com> wrote in message news:MPG.1898caca7b93f5699896e9_at_news.t-online.de...
> In article <3e2ea241$0$2569$afc38c87_at_news.easynet.co.uk>,
> elziko_at_NOTSPAMMINGyahoo.co.uk says...
> > I have noticed that you can query using Number column in SQL like this:
> >
> > SELECT * FROM mytable WHERE numbercol = '100'
> >
> > ...where numbercol is a Number Column! The bit I'm questioning is the quotes
> > around the 100. Normally for a number column you would not use these I know
> > but is there any performance decrease if you do?
> >
> > Cheers,
> >
> > elziko
> >
> >
> >
> Yes, you'll take a performance hit because Oracle has to do a type
> conversion and your index will be ignored.
>
> -- Tom
Received on Thu Jan 23 2003 - 23:56:13 CST