Re: case-insensitive sort

It may or may not be a full table scan. You asked for a case insensitive sort so Oracle will get the results based upon the where clause and then sort the results. So it will probably not be a full table scan. eg select * from emp where dept_no=7 order by upper(last_name); is probably not going to be a full table scan (assuming you have an index of dept_no and the one you have chosen is a small set of the table.). It is just going to sort the results.

the following would (but it isn't a sort, and you asked about a sort not a where)

select * from emp where upper(last_name) like 'SMI%' The above would be a full table scan (no function based index, which is what you need for example 2)
Jim

--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Andrey Voronov" <avoronov_at_diasoft.ru> wrote in message
news:avu70a$2n7l$1_at_gavrilo.mtu.ru...


> And Full Table Scan?

>

> > select ... from mmm where ... order by upper(my_column) asc;

> > That should work. Or did you mean a case insensitive select?

> > Jim

> >

> > --

> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com

> > with family.  Remove the negative part, keep the minus sign.  You can

> figure

> > it out.

> > "Andrey Voronov" <avoronov_at_diasoft.ru> wrote in message

> > news:avtmnj$23ib$1_at_gavrilo.mtu.ru...

> > > How I can implement case-insensitive sort without use function-based

> > index?

>

>

>