SQL indexing on varchar
- by alex
I have a table whose columns are varchar(50) and a float - I need to (very quickly) look get the float associated with a given string. Even with indexing, this is rather slow. I know, however, that each string is associated with an integer, which I know at the time of lookup, so that each string maps to a unique integer, but each integer does not map to a unique string. One might think of it as a tree structure. Is there anything to be gained by adding this integer to the table, indexing on it, and using a query like
SELECT floatval FROM mytable WHERE phrase=givenstring AND assoc=givenint?
This is Postgres, and if you couldn't tell, I have very little experience with databases.