Hi Jonathan
OMG. Yes, of course. Head banging ...
Thanks
Lothar
----Ursprüngliche Nachricht----
Von : jonathan@xxxxxxxxxxxxxxxxxx
Datum : 27/06/2019 - 10:40 (MS)
An : oracle-l@xxxxxxxxxxxxx
Betreff : Re: Re: Index not used to avoid sort with calculated column
With the usual warning that including "invisible" is highly desirable in 12c to
pre-empt the threats of:
select * ....
and
insert without (list of columns)
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of l.flatz@xxxxxxxxxx <l.flatz@xxxxxxxxxx>
Sent: 27 June 2019 08:57
To: tanel@xxxxxxxxxxxxxx
Cc: martin.a.berger@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Re: Index not used to avoid sort with calculated column
Hi Tanel,
thanks for your help. I is good to have collegues who can help. I was
suspecting something like that, but I am up to my neck in work and could not
affort testing on suspicion.
As from the doc I think going for the virtual column being preferrable. It
avoids using an underscore parameter.
drop index e_low_sort1;
alter table emp add (low_job as (lower(job)) virtual);
create index e_low_sort1 on emp (low_job, hiredate);
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
