Dan Black <fireworker@xxxxxxxxx> writes: > First query does not use index in contrast to two query. > > Why? You don't give enough information. Post EXPLAIN ANALYZE output for both queries and perhaps someone can help. -Doug ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match