You may need to get a generic overview of the state of your server: what tables have data ? what fields do I have in each table? etc A...

Applicable to MySQL You may have some queries taking too long to be executed. So, what steps can you take to get a better time execution?...

Here is an example of how to deduplicate a single table with PL/SQL. Context: We have a unique table. The client wants to get a data...

Suppose that you are a very big company with lots of clients and you have a crontab with a very long list of jobs. To go faster you can...