Stoping a query based on data
I have a database to financial/economical purpose that has the economics trades of an entire year.
This is a quite long database (86 milions of rows!!!) and just to change simple things on it takes me quite long time, much longer that I wanted!
The thing is, all my update and select querryes are based on date and my table is organized by date.
Now, my problem: if I want a select querry that returns all trades that have been done before, for an exemple, 05 jan 2010, the mysql search the entire table for dates before 05 jan 2010, and, since the table is organized by date, the querry can stop whenever it finds a date that is grater then the specified!!
Is there any way to do it? to stop a querry whenever I find a date greater then the specified...??
Subject
Written By
Posted
Stoping a query based on data
February 14, 2011 06:58AM
February 14, 2011 08:58AM
February 14, 2011 09:01AM
February 14, 2011 09:25AM
February 14, 2011 09:33AM
February 14, 2011 10:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.