|
|
Posted by Erland Sommarskog on 06/12/77 11:25
ian m via SQLMonster.com (forum@SQLMonster.com) writes:
> I currently have a ms access update query that runs perfectly well and
> quicly in access however I now need to add this query to convert this
> qeryu to oracles equivelant sql syntax and add it to the end of an
> oracle sql script.
>
> Unfortunately Im not having much success although i seem to be able to
> convert it to a working oracle sql. it takes hours to run the statement in
> oracle where as in access it runs in seconds
Without knowledge about the tables, their sizes and the and indexes it is
impossible to tell.
But, stop! don't post that information as a reply to this post. There is
one more thing that is wrong with your post: you are posting to a newsgroup
for SQL Server. What is truth on SQL Server may not be good on Oracle.
So try comp.databases.oracle instead.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|