Comment by listenallyall

The example uses the syntax

  FROM person AS p, gender AS j
  WHERE p.gender_id = j.gender_id

Isn't it preferable to be explicit? Does some of the inefficiency come from lack of explicitness?

  FROM person as p 
  INNER JOIN gender as j
  ON p.gender_id = j.gender_id