Tag: Bind Variables

By Posted on Posted in DBA No Comments Tagged with , , , ,

I recently have had the opportunity to work on performance tuning on Microsoft SQL Server 2005. Recently I have been doing more with performance tuning on Oracle. The following is something that I have discovered to be very similar between Oracle and Microsoft SQL Server, but the names are different between the two systems. So this brings me back to …

How much Procedure Cache memory does one SQL Statement take up? Read more »

By Posted on Posted in Steve No Comments Tagged with , , , , , , ,

MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE rowmun < 10 MySql uses the LIMIT clause. SELECT * FROM tablename LIMIT 10 Bind Variables The latest versions of MySql supports bind variables, and Oracle has supported bind variables for a very long time. …

A Comparison of Oracle and MySQL Read more »