[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Hi, I have a scenario I am having trouble with retrieving data from an archived file, the data was archived form a SQL database using the IBM Optim data growth solution application. I am retrieving data using the DBvisualizer tool and the query I want to make is: select * from tblWFActionlog where DateLogged between '2012/06/01 10:00:00' AND '2012/06/01 11:00:00'
The query runs for a long time and does not return results, it ends up over utilizing the CPU capacity to 100%. Is there an easier way to run this particular query so it returns the results quicker as expected since the data is indexed?
almost 7 years ago
[This reply is migrated from our old forums.]
Re: Retrieval Errors
Regarding syntax errors and ways to construct the query to use indexes, I suggest you ask for advice from the database vendor.
To retrieve a large number of rows without running out of memory, I suggest that you use the @export command to write the result to a file: