Re: SELECT statement efficiency question

On Mon, 09 Apr 2007 04:36:13 +0000, Mladen Gogala wrote:

> For a nightly batch
> job, the difference may be huge.

BTW, cleanup also showed a huge difference: SQL> drop table ind_txt purge;

Table dropped.

Elapsed: 00:00:03.48
SQL> drop table no_ind_tst purge;

Table dropped.

Elapsed: 00:00:00.09
SQL>

-- 
http://www.mladen-gogala.com