Gj’s SQL blog

April 19, 2009

on using different types in joins, and performance of it

Filed under: index, joins, postgresql — Gregg Jaskiewicz @ 4:44 pm

I get this question quite often from folks I work with, or people I join in their projects, usually with database designed by someone who is not very experienced in database world.

Most of them, don’t understand why the hell I am pressing for using bigint/int as a key to a table.

Here’s simple example, and my own theory behind it.

(more…)

Advertisements

Create a free website or blog at WordPress.com.