Sac, this is like saying I have a pain, what can it be? Attach more info if you hope in some help, at least the explain plan.
Cheers Claudio 2010/1/13 F.A.I.Z.A.L <sac.fai...@gmail.com> > hi > > can anybody help me to check this query is written in good way > > select ATX_Status.Server as `Server`, ATX_Status.Load as > `Load`,ATX_Status.System as `System`, > atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`, > atx.ATX_Summary.Testware as `View`, `Traffic`, > ATX_Status.Status as `Status`, ATX_Request.Requestor as `Requestor`, > atx.ATX_Summary. > Logs as `Logs`, `Priority`, `Server_IP_Address`, > atx.ATX_Request.isHostBuild > as `isHost`, > atx.ATX_WebLogs.Logs as `WLogs`, `TestRun`, `PRequestor`, `Reason`, > `AbortRqstr`, > DATE_SUB( str_to_date(ATX_Status.Timestamp, '%m%d%Y-%H'), INTERVAL > ATX_Time.TimeDiff HOUR_MINUTE) > as `ConvTime`, ATX_Reruns.isRerun as rerun, ATX_Reruns.comment as > reruncomment, atx.ATX_RuntimeStats. > lbtStartTime, atx.ATX_RuntimeStats.runStartTime, > atx.ATX_RuntimeStats.totalRunDuration > from atx.ATX_Status > left join atx.ATX_Request on atx.ATX_Request.Timestamp = > atx.ATX_Status.Timestamp > left join atx.ATX_WebLogs on atx.ATX_Status.Timestamp = > atx.ATX_WebLogs.Timestamp > left join atx.ATX_Server on atx.ATX_Status.Server = > atx.ATX_Server.Server_Name > left join atx.ATX_Time on atx.ATX_Server.Server_Location = > atx.ATX_Time.Server_Location > left join atx.ATX_RuntimeStats on atx.ATX_Status.Timestamp = > atx.ATX_RuntimeStats.Timestamp > left join atx.ATX_AbortedJobs on atx.ATX_Status.Timestamp = > atx.ATX_AbortedJobs.Timestamp > left join atx.ATX_Reruns on atx.ATX_Status.Timestamp = > atx.ATX_Reruns.Timestamp > left join atx.ATX_Summary on atx.ATX_Summary.Timestamp = > atx.ATX_Status.Timestamp > where ( > ATX_Status.Status like '%running%' or ATX_Status.Status like '%queued%' or > ATX_Status.Status like '%migrating%' or ATX_Status.Status like '%loading%' > or > ATX_Status.Status like '%configuring%' or ATX_Status.Status like > '%activating%' ) > and ATX_Server.Server_Status=1 and ATX_Status.isAlive=1 > and ATX_Status.Server = 'ALIL-CHN RLAB' > and ATX_Status.System = 'ETSI-NFXSA-NANTA-ISAM-01' > and ATX_Status.Load = 'SD_4003.418' and str_to_date(ATX_Status.Timestamp, > '%m%d%Y') > > thanks in advance > > Cheers > Faizal S > GSM : 9840118673 > Blog: http://oradbapro.blogspot.com > -- Claudio
