SQL for Data Warehousing and Analytics

MATCH_RECOGNIZE and predicates At a recent user conference I had a question about when and how  predicates are applied when using MATCH_RECOGNIZE so that’s the purpose of this blog post. Will this post cover everything you will ever need to know for this topic? Probably! Where to start….the first thing to remember is that the table listed in the FROM clause of your SELECT statement acts as the input into the MATCH_RECOGNIZE pattern matching process and this raises the question about how and where are predicates actually applied. I briefly touched on this topic in part 1 of my deep dive series on MATCH_RECOGNIZE: SQL Pattern Matching Deep Dive - Part 1 . In that first post I looked at the position of predicates within the explain plan and their impact on sorting. In this post I am going to use the built in measures (MATCH_NUMBER and CLASSIFIER) to show the impact of applying predicates to the results that are returned. First, if you need a quick refresher course in...

  ….and now it’s here in PDF format as well!   The free big data warehousing Must-See guide for OpenWorld 2017 is now available for download in PDF format - click here , and yes it’s completely free . This comprehensive guide covers everything you need to know about this year’s Oracle OpenWorld conference so that when you arrive at Moscone Conference Center you are ready to get the most out of this amazing conference. The guide contains the following information: Page 8 - On-Demand Videos Page 17 - Justify Your trip Page 19 - Key Presenters Page 41 - Must See Sessions Page 90 - Useful Maps Chapter 1  - Introduction to the must-see guide. Chapter 2  - A guide to the key the highlights from last year’s conference so you can relive the experience or see what you missed. Catch the most important highlights from last year's OpenWorld conference with our on demand video service which covers all the major keynote sessions. Sit back and enjoy the highlights. The...

  It’s here - at last! I have just pushed my usual must-see guide to the Apple iBooks Store.   The free big data warehousing Must-See guide for OpenWorld 2017 is now available for download from the Apple iBooks Store - click here , and yes it’s completely free . This comprehensive guide covers everything you need to know about this year’s Oracle OpenWorld conference so that when you arrive at Moscone Conference Center you are ready to get the most out of this amazing conference. The guide contains the following information: Page 8 - On-Demand Videos Page 17 - Justify Your trip Page 19 - Key Presenters Page 41 - Must See Sessions Page 90 - Useful Maps Chapter 1  - Introduction to the must-see guide. Chapter 2  - A guide to the key the highlights from last year’s conference so you can relive the experience or see what you missed. Catch the most important highlights from last year's OpenWorld conference with our on demand video service which covers all the ...