David B wrote: > We have got used to the problem that queries of the format: > > select * > from customer > where cust_id = '123' are much much faster than > > select * > from customer > where cust_id = 123 > > (where cust_id is defined as bigint). > > a. Why is this.
Because in the second case, the 123 gets resolved too early to type integer, which is not index compatible with type bigint. > b. Will moving to v7.4 change this so we can avoid the whole '123' > casting thing. No, but 7.5 will be able to handle it. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
