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] -----------------------------------------------------------------------------