Select Top x

#1

Hi.
Does "Select top x from y" perform a "full table scan"?

#2

On 3 Feb., 11:05, darkwerks <pazr... (AT) darkwerks (DOT) de> wrote:

Quote:

Hi.
Does "Select top x from y" perform a "full table scan"?

With out a sort order the result is not deterministic.
If your order clause is supported by an index it is using an index
scan.

HTH
Thomas

#3

On 3 Feb., 12:35, tduemesnil <tduemes... (AT) googlemail (DOT) com> wrote:

Quote:

On 3 Feb., 11:05, darkwerks <pazr... (AT) darkwerks (DOT) de> wrote:

Hi.
Does "Select top x from y" perform a "full table scan"?

With out a sort order the result is not deterministic.
If your order clause is supported by an index it is using an index
scan.

HTH
Thomas

Yes of course, but want i meant was: Does TOP x reads/scans/loads the
whole table.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Select Top x

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Select Top x - 02-03-2010 , 05:05 AM

Re: Select Top x - 02-03-2010 , 06:35 AM

Re: Select Top x - 02-03-2010 , 09:39 AM