Re: How does the FILTER operation work?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 28 May 2018 14:25:15 +0000
Message-ID: <LO1P123MB09778217448D7E37E1734D0BA56E0_at_LO1P123MB0977.GBRP123.PROD.OUTLOOK.COM>

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_at_uis.cam.ac.uk> 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.

Correct.

> 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.

Thanks. It seems an achievement to be able to ask a question you consider worthy of a blog post. Now I just need to progress to answering them myself!

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 28 2018 - 16:25:15 CEST