Optimize Maxmind database loaded on Redshift using Analytical functions

If you need to associate an IP address to a country or a city probably you will use MaxMind data. If you load it in a relational database you will write a SQL statement that joins your traffic data with MaxMind data, which can be really heavy. This is an attempt to optimize queries by reducing the number of MaxMind data rows.

AWS
Redshift
SQL

Redshift tips

I am using Redshift since two years ago, and as every database it has its SQL dialect and its secrets. I will write here everything I discover and it is worth to be annotated.

AWS
PostgreSQL
Redshift
SQL

sqlplus tips

Tricks and tips about your everyday Oracle sqlplus usage.

Oracle
SQL