I have an ODBC connection to an Oracle 8 database. All of the queries I have run so far seem to run pretty quickly. I have one now that takes about 10-12 minutes to execute. It takes about 2 second in SQL+. The table is about 67000 records.

= sqlexec(liconnect,"select * from wps_mgr.ws_scale_ticket where ; ws_scale_ticket.permit_no like 'BC%-2' and ;
ws_scale_ticket.ticket_date >= 20020401 and ;
ws_scale_ticket.ticket_date <= 20030331","tictemp")

Any suggestions would be appreciated.