Archives of the TeradataForum

Message Posted: Mon, 07 Feb 2011 @ 13:51:51 GMT

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

<-- Anonymously Posted: Monday, February 7, 2011 08:49 -->

Hi Experts ,

I have a following query :

If on the same table I fire the following 4 queries , which one will execute faster ? (rather how PE interprets them ?)

1) SELECT * FROM

2) SELECT COUNT(*) FROM

3) SELECT * FROM

4) SELECT TOP n * FROM

Thanks .

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