Is there any way to determine if a query is using an index or not? In
PostgreSQL the "explain" works to tell whether a table is being
sequentially scanned or not..
I have a query :
SELECT *,(total - balance_due) as total_paid FROM invoice_master WHERE
lower(invoice_number) LIKE lower('%%') AND status != 'Void' AND
status != 'Recur' AND status != 'Paid' AND status != 'Forwarded'
ORDER BY created ASC LIMIT 25
The lower('%%') gets used with whatever field the user is searching on.
I have indexes on created, status and invoice_number - but apparently
I can't make an index on lower(invoice_number) -- can I?
--
- Mitchell Vincent
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
