Sql, Technology, Programming, Machine Learning, Data Science.
majority of the time, it takes longer to read from the disk subsystem than it does to decompress the data. If the bottleneck is at the I/O level, using compression helps reducing the size of the table or index on the disk and speeds up the query execution. Use Same Datatype on JOIN and WHERE