• No replies
1 Post

Pinned topic Archive file retreival

‏2014-02-10T06:42:27Z |
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?