I’m in the process of writing a number of new presentations and in one I’ve included a favorite little graph of mine that I’ve used over the years to help illustrate the relationship between the cost of using an index vs. the cost of using a Full Table Scan (FTS). It’s occurred to me that I’ve never actually [...]
Happy Friday! I thought I would jumpstart your creative juices with this little, really simple quiz. While it's trivial, it may not be that obvious to many. See if you can catch it. Time yourself exactly 1 minute to get the answer. Tweet answer to me @arupnanda
Here it goes. Database is 220.127.116.11. Tool is SQL*Plus.
The user ARUP owns a procedure that accepts an input string and executes it. Here is the procedure.
There was a question on the OTN database foruma little while ago about the different between the relative and absolute files numbers for a data file as reported in view dba_data_files – where they appear as file_id and relative_fno – or v$datafile – where they appear as file# and rfile#.
Heads up!!! The first MySQL/MariaDB/NoSQL Latin America event is on its way and Pythian will have a MySQL guy there. Yes, Francisco Bordenave (Team 14 TTL) is going to be one of the speakers. I am presenting a conference about Replication in MySQL, how to’s and what’s new in newer versions. This is a very important event [...]
One of the biggest problems in software performance today occurs when the people who write software are different from the people who are required to solve the performance problems that their software causes. It works like this: