Zoltan Boszormenyi <[EMAIL PROTECTED]> writes: > $ time echo "select * from v_invoice_browse where code||inv_no = > 'CARO200000020'" | dbaccess db
> Is there a way to speed this operation up? Make an expression index on "code||inv_no", if you think this case is important enough to be worth maintaining an extra index for. (This is not on-topic for -hackers, IMHO. Try pgsql-perform.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly