Saturday, June 28, 2014

KScope14 - on my way home

For some reasons I got lounge access here at Seattle airport when going home fra KScope14. So I can use the last couple hours here lounging comfortably writing a few words about an awesome week here.

Monday, June 23, 2014

MEMBER OF comparison of PL/SQL and SQL

In the Kscope14 sunday symposium today, Steven Feuerstein explained that MEMBER OF syntax was slow in SQL and fast in PL/SQL. I challenged him that perhaps it was missing indexes on the nested table? My mistake - I got the task of testing it and see if that was the case... So I tested and was surprised at the answer.

UPDATE 2014-10-16: Based on Iudiths comment to this post, I decided to re-test this - both to delve a bit deeper into whether she has a point or not, and also to try it out on a 12.1.0.2.0 instance.

Saturday, June 14, 2014