Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 19:15:23 GMT

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

Hi

In case of Oracle if it is select * from tablename it will be a FTS (Full Table Scan)

For Oracle to use the Index use the primary key or the index column of the table in the where clause.

Thanks

Raghavendran V

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