From: caoimhinocrosbai@yahoo.com   
      
   Thanks for the advice Ed,   
      
   I've decided to go a different route anyway, I'll do asynchronous calls   
   between my applications rather than send to databases and read again.   
      
   Thanks.   
   "Ed prochak"  wrote in message   
   news:4b5394b2.0405110918.2e17ece5@posting.google.com...   
   > "Kevin Crosbie"  wrote in message   
   news:<483a35a26fdbecb0a8af95c8056e2ed9@news.teranews.com>...   
   > > Hi all,   
   > > (Sorry for the cross-post, there doesn't appear to be much activity on   
   > > comp.database.oracle)I'm trying to get the last 300 rows from the   
   difference   
   > > between 2 large   
   > > tables and my queries are taking at least 10 minutes to do this.   
   > []   
   > >   
   > > Can anybody think any way I can improve these?   
   > >   
   > > Thanks,   
   > >   
   > > Kevin   
   >   
   > you picked another defunct group. Post one last time to   
   >    comp.databases.oracle.misc   
   > and you'll get some suggestions.   
   >   
   > I'll give you one quick comment here: the phrase "the last 300 rows"   
   > is meaningless in a relational database. This isn't a file system,   
   > rows have no location relative to each other. You'll do better to   
   > eliminate such phrases from your vocabulary and describle what you   
   > really mean or need.   
   >   
   > See you in .misc   
   >   Ed   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)