Why Is My SQL Slow & Go Faster Features

thatjeffsmith SQL Developer 19 Comments

Yesterday I made my first presentation ever at the annual Hotsos conference. The topic: “All of the Performance Tuning Features in SQL Developer.” It went pretty well, and I’d like to share those slides now with y’all: Tuning & Diagnostics Features in Oracle SQL Developer from Jeff Smith Easier to Read Autotrace Execution Plans Apparently I said ‘explain plan’ too …

Dimensional Modeling in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 12 Comments

Oracle SQL Developer Data Modeler (SDDM) is a free data modeling solution. It supports many types of modeling levels, including: logical relational physical (multi-)dimensional When I present overviews on our database tools, I have this slide that shows what SDDM is capable of: I am not a real data modeler. However, I can fake my way pretty well through Logical …