Archives of the TeradataForum

Message Posted: Thu, 02 Oct 2008 @ 08:26:18 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Sub-queries doesn't use Secondary Indexes and SQL-1 is using sub-query.

You can change like this.. Hope this will use Secondary Index.

     select
     A.bla
     from my_table
     (select max(load_dte) from another_table) b (LDate)
     where a.period_dte = b.Ldate
     ;

Thanks.

Best Regards,

Kapil Dev Sapra

	<Prev	Next>		<<First	<Prev	Next>	Last>>