0
POPSOracle RAC Overview Oracle RAC technology sounds pretty cool. I've worked with Microsoft SQL Server clusters before, but never with Oracle. I'm interested in learning more, especially since it's looking like I'll need to deal with Oracle a lot more in my next job. :-)
0
POPSTable Spool should alert you to a potential problem I was looking at a query plan today and saw a Table Spool icon. I had never seen one of those before. I thought that it might not be so great. I found this little bit of text on spooling data to work tables and thought it was interesting.
0
POPSDesign queries using SHOWPLAN turned on Yeah, this makes a lot of sense to do. I hadn't thought of it like that before. I've found myself turning Execution Plan on when working on complex procedures, but I don't make it part of my regular habit. I think this practice will be good for me to start doing.
Latest Pops
see Latest Pops
Clips
Comments
Tags
8
by tiffieau 
Most Pops
Print
Save
Turn on live update