in the below query i'm returning only 50 rows but it is taking 15sec to execute. Index are already used.
any help?
- SELECT WP_TimerName, WP_WeldJobName, WP_Comment, WP_SpotName, WP_WeldJobVersion,
- WP_LogNo, WP_TipWearCount, WP_TipDressCount, WP_UnixEpoch, WP_uirModeOff, WP_MonitorState, WP_MonitorErrorCode, WP_SpotRepetition,
- WP_GhostRunMode, WP_GunName, WP_GunResistance, WP_TimerId, WP_CurrentMeasurementState, WP_VoltageMeasurementState, WP_ForceMeasurementState,
- WP_PositionMeasurementState, WP_ContactWaitTime, SBP.Id SequenceBlock_Id, BP_SequenceBlockNo, BP_ForceOffset, BP_OffsetPosition, BP_SequenceBlockType, BP_UIP,
- BP_FQF, BP_MeanCurrent, BP_MeanForce, BP_MeanPosition, BP_MeanPulse, BP_MeanResistance,
- BP_MeanVoltage, BP_RegulationMode, BP_Energy, BP_GunResistance, WP_STCReference, WP_STCTeachName, BP_UIP, BP_CurrentCurve,
- BP_VoltageCurve, BP_ForceCurve, BP_PulseCurve, BP_PositionCurve, BP_ScheduledBlockNo, BP_Length, BP_PSF, BP_spatterTime,
- BP_TypeOrderNo , WP_ForceSensorScalFactor3 , WP_ForceSensorScalFactor2 , WP_ForceSensorScalFactor1 , WP_ForceSensorScalConstant ,
- WP_PositionMeasurementState , BP_OffsetPosition ,BP_MeanPosition ,BP_PositionCurve ,BP_ReferenceCurveLength ,
- BP_MonitorStdActualValue ,BP_MonitorStdReferenceValue ,BP_MonitorStdUpperToleranceBandPerc ,BP_Indentation ,BP_MonitorStdLowerToleranceBandPerc ,
- BP_MeanTorque,BP_PQF
- FROM WeldProtocol_Log_T WP
- INNER JOIN
- SequenceBlockProtocol_Log_T SBP
- ON WP.Id = SBP.BP_WeldProtocol_Log_T_Id
- WHERE 1=1
- AND ((BP_SequenceBlockType=1 AND BP_TypeOrderNo=1))
- ORDER BY
- WP_UnixEpoch DESC,
- WP_LogNo DESC
- LIMIT 50 OFFSET 117050;