Oracle Magazine, July/August 2017

Database Application Developer and DBA BEYOND SQL 101 ORACLE DATABASE Meta Access and Repetitive Composition Part 10 in a second series on the basics of the relational database and SQL This article is the 10th in a series that helps you build on the fundamentals you learned in the 12 part SQL 101 series in Oracle Magazine The previous Beyond SQL 101 article The Cost of Data Retrieval introduced bitmap indexes You discovered how to create them and when they might be an appropriate index choice You also learned how bitmap indexes should not be used in a database with regular transaction activity but instead in a data warehouse with occasional bulk loads of data You were introduced to Oracle Databases Oracle Optimizer program SQL statement processing operations and parsing You learned what a bind variable is and how it can help reduce parsing activity Finally you learned about statistics and the creation ORACLE MAGAZINE JULY AUGUST 2017 101 and display of execution plans By Melanie Caffrey

View the Covers and the Table of Contents pages from every issue of this publication, all gathered together for easy browsing. Just flip pages and zoom as you normally do to see each issue's Cover and Table of Contents, then follow links directly to interesting content.