sort

[beginner]

i know order by will use sort_area.

but what if i have a index on that column?

create table test(a int,b int);
insert to test some values.

select * from test where a>10;

does this one use sort_area?

[amar]

Where is the ORDER BY clause?

-amar

[pipo]

if you have an index on a, you'll issue a RANGE SCAN, but no data will be sorted since, as amar said, you never specify that you want something to be ordered ...

[beginner]

sorry. it should be
select * from test where a>10 order by a ;

[chrisrlong]

Most likely not, but it depends on whether or not the index is used.

Check the plan for the statement. If there is no SORT step, then sort_area will not be used.

- Chris