Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL query time out in ORACLE db
In message <1127491886.694839.223400_at_f14g2000cwb.googlegroups.com>,
gilroy.ponniah_at_gmail.com writes
>Hi David,
>
>You are absolutely correct. We talk about it too. However, ACCPAC is
>a small medium accounting package used by millions of people around the
>world. Unfortunately I work as Consultant for a solution provider.
>ACCPAC runs on ORACLE, SQLServer, DB2 and Pervasive database servers.
>
>I rename the column to 'VALUE1' and tried the same query with
>'VALUE1' as column name and got the same behavior with no result. Any
>other suggestions???
Try investigating. Run explain plan and post it here.
-- Jim Smith Because of their persistent net abuse, I ignore mail from these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw For an explanation see <http://www.jimsmith.demon.co.uk/spam>Received on Fri Sep 23 2005 - 13:19:54 CDT