Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: too many gets per execution
Sure there is, did you try an explain plan to get the execution plan
for each statement or check indexes on involved tables? I didn't tried
it out, but it would expect such/some problems, if i'd use queries
tuned for others databases. It seems oracle optimizer has some trouble
with it and sybase not, so use hints or better rewrite the queries.
Regards Received on Thu Jan 31 2002 - 04:04:46 CST