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.
Received on Wed Jan 22 2003 - 08:36:16 CST
