Re: selecting the differences between 2 large tables

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" <ed.prochak_at_magicinterface.com> wrote in message news:4b5394b2.0405110918.2e17ece5_at_posting.google.com...
> "Kevin Crosbie" <caoimhinocrosbai_at_yahoo.com> wrote in message
news:<483a35a26fdbecb0a8af95c8056e2ed9_at_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
Received on Tue May 18 2004 - 09:50:46 CEST