I've gotten to see Jean-Pierre Djicks speak a couple of times over the last month or so, and he doesn't disappoint. Last month at th...

Let's say you have DEGREE set at the table and index level. I ask you if this is appropriate, instead offering up using whatever tool ac...

I'm trying to learn about PARALLEL and how it affects SELECT statements in a DW/DSS (non OLTP) environment. I can't really say I kn...

I found this article through the OraNA feed by ProdLife which talked about running a report that was based on multiple queries. It remi...