Paul,
Wrote it up, forgot to make a fuss about publishing it:
https://jonathanlewis.wordpress.com/2018/05/28/filtering-lobs/
Regards
Jonathan Lewis
________________________________________
From: Jonathan Lewis
Sent: 25 May 2018 14:06:04
To: 'Oracle Mailinglist'
Subject: Re: How does the FILTER operation work?
Paul,
Flattery gets you everywhere!
I didn't find time to complete the write-up, so today's blog note is just a
quick SQL*Plus tip, but I should finish the costing thing over the weekend and
publish Monday.
Regards
Jonathan Lewis
________________________________________
From: Paul Houghton <Paul.Houghton@xxxxxxxxxxxxx>
Sent: 25 May 2018 13:59
To: Jonathan Lewis; 'Oracle Mailinglist'
Subject: RE: How does the FILTER operation work?
I think you'll also find that the emplid is declared not null.
I've done a little experimental work - the oddity of costing is all about
the LOBINDEX. I'll > be writing a blog note about it tomorrow.