Fraud Blocker

Improve MySQL performance with indices and Explain.

Enabling profiling is an affordable way to get an accurate estimate of the time the request has been executed. First you need to enable profiling and …

Continue Reading

Oracle SUM function.

The Oracle/PLSQL SUM function returns the total value of the expression….

Continue Reading

Oracle SQRT function.

The Oracle/PLSQL SQRT function extracts the square root from the number….

Continue Reading

How to output a CSV file using SQLPLUS Spool?

I want to output several queries in CSV format without using SQL-client or programming language, using only SQLPlus. How to do it?…

Continue Reading

Oracle NEXT_DAY function.

Oracle/PLSQL NEXT_DAY function returns the first day of the week that is larger than date….

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.