Re: Interview Index problem

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