Re: who can explain me what is "OR-expansion"???

On Sat, 15 Mar 2003 19:33:40 +0800, "zhanggp" <zhangguoping_at_boco.com.cn> wrote:

>thks
>

example
select name from emp where empno in (10,20,30) will be transformed behind the scenes in select name from emp where empno = 10 or empno = 20 or empno = 30 The optimizer will execute those as separate query blocks, using an index, the query results are merged as a final step.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Mar 15 2003 - 06:51:56 CST