SQL SELECT speed int vs varchar

by

Int comparisons are faster than varchar comparisons, for the simple fact that ints take up much less space than varchars.

This holds true both for unindexed and indexed access. The fastest way to go is an indexed int column.

As I see you’ve tagged the question postgreql, you might be interested in the space usage of different date types:

More Related Contents:

  1. Best way to select random rows PostgreSQL
  2. Optimise PostgreSQL for fast testing
  3. Normalize array subscripts so they start with 1
  4. Are there any way to execute a query inside the string value (like eval) in PostgreSQL?
  5. Fastest way to determine if record exists
  6. Why postgres returns unordered data in select query, after updation of row?
  7. SQL column reference “id” is ambiguous
  8. Get execution time of PostgreSQL query
  9. What is the fastest way to truncate timestamps to 5 minutes in Postgres?
  10. “SELECT *” vs “SELECT ” for performance
  11. How to return result of a SELECT inside a function in PostgreSQL?
  12. Possible to perform cross-database queries with PostgreSQL?
  13. Reset auto increment counter in postgres
  14. JOIN two SELECT statement results
  15. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  16. GROUP BY and aggregate sequential numeric values
  17. Safely rename tables using serial primary key columns
  18. How do I determine the last day of the previous month using PostgreSQL?
  19. How many rows in a database are TOO MANY?
  20. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  21. SQL count(*) performance
  22. Why is a UDF so much slower than a subquery?
  23. How much disk-space is needed to store a NULL value using postgresql DB?
  24. Does Postgres support nested or autonomous transactions?
  25. PostgreSQL delete with inner join
  26. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  27. Update a column of a table with a column of another table in PostgreSQL
  28. Check if NULL exists in Postgres array
  29. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  30. Temporal database design, with a twist (live vs draft rows)

Leave a Comment