Thank you very much Erwann, but it does not help. There is no visible improvement.
Grigori G. Solonovitch -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Erwann SIMON Sent: Sunday, August 21, 2011 4:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Query performance issue Hi Grigori, Try to first add a clause that limit the scope of the search to avoid calculation on the entire actlog table, something like "... where date(current_timestamp)=current_date and cast((current_timestamp-date_time)minutes as decimal)<3 ..." Best regards / Cordialement / مع تحياتي Erwann SIMON Le 21/08/2011 12:38, Grigori Solonovitch a écrit : > TSM Client 6.2.3.0& TSM Server 5.5.5. > > Is there any way to speed up next request? > > select msgno, severity, message, originator, nodename, ownername, schedname, > domainname, servername, sessid, session, process, date_time as > date_time > from actlog > where cast((current_timestamp-date_time)minutes as decimal)<3 > ORDER BY date_time DESC > > Thank you very much in advance. > > Grigori G. Solonovitch > > > CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail > message and any attachments hereto may be legally privileged and > confidential. The information is intended only for the recipient(s) named in > this message. If you are not the intended recipient you are notified that any > use, disclosure, copying or distribution is prohibited. If you have received > this in error please contact the sender and delete this message and any > attachments from your computer system. We do not guarantee that this message > or any attachment to it is secure or free from errors, computer viruses or > other conditions that may damage or interfere with data, hardware or software. > > Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software.
