Re: Interview Index problem

"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message news:pan.2006.05.30.01.33.20.191837_at_sbcglobal.net...
> On Mon, 29 May 2006 21:50:04 +0100, Jonathan Lewis wrote:
>
>> If 1,000 is a very high salary, paid to just a few people,
>
> Johnatan, USD is sinking like a rock. If company is paying $1000,
> it's Wal-Mart, paying the illegal immigrants. So, it's very many
> employees. Depending on the statistics, CBO can select either index.
> That is why query should have been written like this:
>
> "select empno,ename,sal,deptno from emp where deptno=10 and sal+0>1000"
>
> Now, there is no more doubt.
>
> --
> http://www.mgogala.com
>

Never make assumptions about other people's data.

How do you know which currency, which country, and whether the rate is per hour, per day, per week or per year ?

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html