We have a server that is pulling a bazillion rows via JDBC (I think) daily.
Unfortunately, we are stuck with this process as is for a while until we can
get a project on the plan to pull only net changes. It currently runs for
2-3 hours each day.
What is the fastest way to pull this data? Will it be faster to omit the
order by clause and just let SQL hand back data in whatever order that it
wants or would it be quicker to add an order by clause. It seems like
having an order by clause would slow it down because the file is not in any
particular sequence but I also didn't know if an order by RRN would help.
Any thoughts (other than rewriting the process which is in the plans but
probably not for this year)?
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
