SQL语句优化,SQL语句性能优化,改写求助

以下是一段sql语句,效率非常低, 请求帮忙优化一下

 SELECT *
FROM bas_Achieve a
    LEFT JOIN bas_PlayerAchieve b ON a.A_ID = b.PA_Achieve
WHERE PA_Player = @Player
    AND CAST(A_ID AS varchar(max)) + A_Value1 IN (SELECT CAST(A_ID AS varchar(max)) + MIN(A_Value1)
        FROM bas_Achieve a, bas_PlayerAchieve b
        WHERE a.A_ID = b.PA_Achieve
            AND PA_Player = @Player
            AND a.A_Value1 > b.PA_Value
        GROUP BY A_ID)
    OR CAST(A_ID AS varchar(max)) + A_Value1 IN (SELECT CAST(A_ID AS varchar(max)) + MAX(A_Value1)
        FROM bas_Achieve a, bas_PlayerAchieve b
        WHERE a.A_ID = b.PA_Achieve
            AND PA_Player = @Player
            AND a.A_Value1 < b.PA_Value
        GROUP BY A_ID)
ORDER BY A_ID

不好意思..
以下是执行计划xml

 <?xml version="1.0" encoding="utf-16"?>
<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.1600.1" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
  <BatchSequence>
    <Batch>
      <Statements>
        <StmtSimple StatementCompId="1" StatementEstRows="8323.15" StatementId="1" StatementOptmLevel="FULL" StatementSubTreeCost="47.6064" StatementText="select  [A_ID],[A_Name],[A_Info],[A_Condition],[A_Value1],[A_Reward],[A_Value2],[A_Rewardinfo],[PA_Player]&#xD;&#xA;,[PA_Achieve],[PA_Value],[PA_Flag1],[PA_Flag2] from bas_Achieve a left join bas_PlayerAchieve b on a.A_ID = b.PA_Achieve where PA_Player ='o_EJvxL2OGpqFwvPI_0tkcN-UDZc' &#xD;&#xA;and cast(A_ID as varchar(max))+A_Value1 in (select cast(A_ID as varchar(10))+min(A_Value1) from bas_Achieve a,bas_PlayerAchieve b where a.A_ID = b.PA_Achieve and PA_Player ='o_EJvxL2OGpqFwvPI_0tkcN-UDZc' and a.A_Value1 &gt; b.PA_Value group by A_ID) &#xD;&#xA;  or cast(A_ID as varchar(max))+A_Value1 in (select cast(A_ID as varchar(10))+max(A_Value1) from bas_Achieve a,bas_PlayerAchieve b where a.A_ID = b.PA_Achieve and PA_Player ='o_EJvxL2OGpqFwvPI_0tkcN-UDZc' and a.A_Value1 &lt; b.PA_Value group by A_ID) &#xD;&#xA;order by A_ID&#xD;&#xA;" StatementType="SELECT" QueryHash="0xDC6E1845D70D13F6" QueryPlanHash="0xC931AC2CD61C4881">
          <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
          <QueryPlan CachedPlanSize="80" CompileTime="20" CompileCPU="20" CompileMemory="1024">
            <RelOp AvgRowSize="918" EstimateCPU="0.0386564" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="8323.15" LogicalOp="Left Semi Join" NodeId="0" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="47.6064">
              <OutputList>
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Name" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Info" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Condition" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Reward" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value2" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Rewardinfo" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag1" />
                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag2" />
              </OutputList>
              <NestedLoops Optimized="false">
                <OuterReferences>
                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                </OuterReferences>
                <RelOp AvgRowSize="918" EstimateCPU="0.0291642" EstimateIO="0.01878" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="9247.95" LogicalOp="Right Outer Join" NodeId="1" Parallel="false" PhysicalOp="Merge Join" EstimatedTotalSubtreeCost="0.211871">
                  <OutputList>
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Name" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Info" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Condition" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Reward" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value2" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Rewardinfo" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag1" />
                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag2" />
                  </OutputList>
                  <Merge ManyToMany="true">
                    <InnerSideJoinColumns>
                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                    </InnerSideJoinColumns>
                    <OuterSideJoinColumns>
                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                    </OuterSideJoinColumns>
                    <Residual>
                      <ScalarOperator ScalarString="[VR_SG].[dbo].[bas_Achieve].[A_ID] as [a].[A_ID]=[VR_SG].[dbo].[bas_PlayerAchieve].[PA_Achieve] as [b].[PA_Achieve]">
                        <Compare CompareOp="EQ">
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                            </Identifier>
                          </ScalarOperator>
                          <ScalarOperator>
                            <Identifier>
                              <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                            </Identifier>
                          </ScalarOperator>
                        </Compare>
                      </ScalarOperator>
                    </Residual>
                    <RelOp AvgRowSize="83" EstimateCPU="0.100307" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5100" LogicalOp="Sort" NodeId="2" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="0.15972">
                      <OutputList>
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag1" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag2" />
                      </OutputList>
                      <MemoryFractions Input="1" Output="1" />
                      <Sort Distinct="false">
                        <OrderBy>
                          <OrderByColumn Ascending="true">
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                          </OrderByColumn>
                        </OrderBy>
                        <RelOp AvgRowSize="83" EstimateCPU="0.005767" EstimateIO="0.0423843" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="5100" LogicalOp="Clustered Index Scan" NodeId="3" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.0481513" TableCardinality="5100">
                          <OutputList>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag1" />
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag2" />
                          </OutputList>
                          <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag1" />
                              </DefinedValue>
                              <DefinedValue>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Flag2" />
                              </DefinedValue>
                            </DefinedValues>
                            <Object Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Index="[PK_BAS_PLAYERACHIEVE]" Alias="[b]" TableReferenceId="1" IndexKind="Clustered" />
                          </IndexScan>
                        </RelOp>
                      </Sort>
                    </RelOp>
                    <RelOp AvgRowSize="843" EstimateCPU="0.0003385" EstimateIO="0.00386574" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="165" LogicalOp="Clustered Index Scan" NodeId="4" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00420424" TableCardinality="165">
                      <OutputList>
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Name" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Info" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Condition" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Reward" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value2" />
                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Rewardinfo" />
                      </OutputList>
                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                        <DefinedValues>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Name" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Info" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Condition" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Reward" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value2" />
                          </DefinedValue>
                          <DefinedValue>
                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Rewardinfo" />
                          </DefinedValue>
                        </DefinedValues>
                        <Object Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Index="[PK_BAS_ACHIEVE]" Alias="[a]" TableReferenceId="1" IndexKind="Clustered" />
                      </IndexScan>
                    </RelOp>
                  </Merge>
                </RelOp>
                <RelOp AvgRowSize="9" EstimateCPU="5.22675E-07" EstimateIO="0" EstimateRebinds="9246.65" EstimateRewinds="0.296296" EstimateRows="1" LogicalOp="Concatenation" NodeId="6" Parallel="false" PhysicalOp="Concatenation" EstimatedTotalSubtreeCost="47.3558">
                  <OutputList />
                  <Concat>
                    <DefinedValues />
                    <RelOp AvgRowSize="9" EstimateCPU="2.14083E-05" EstimateIO="0" EstimateRebinds="9246.65" EstimateRewinds="0.296296" EstimateRows="1" LogicalOp="Filter" NodeId="7" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="47.3549">
                      <OutputList />
                      <Filter StartupExpression="false">
                        <RelOp AvgRowSize="73" EstimateCPU="1.98225E-06" EstimateIO="0" EstimateRebinds="9246.65" EstimateRewinds="0.296296" EstimateRows="10" LogicalOp="Compute Scalar" NodeId="8" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="47.255">
                          <OutputList>
                            <ColumnReference Column="Expr1008" />
                            <ColumnReference Column="Expr1016" />
                          </OutputList>
                          <ComputeScalar>
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Column="Expr1016" />
                                <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),CONVERT(varchar(10),[VR_SG].[dbo].[bas_Achieve].[A_ID] as [a].[A_ID],0),0)">
                                  <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
                                    <ScalarOperator>
                                      <Convert DataType="varchar" Length="10" Style="0" Implicit="false">
                                        <ScalarOperator>
                                          <Identifier>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </Convert>
                                    </ScalarOperator>
                                  </Convert>
                                </ScalarOperator>
                              </DefinedValue>
                            </DefinedValues>
                            <RelOp AvgRowSize="65" EstimateCPU="2.18048E-05" EstimateIO="0" EstimateRebinds="9246.65" EstimateRewinds="0.296296" EstimateRows="10" LogicalOp="Aggregate" NodeId="9" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="47.2458">
                              <OutputList>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                <ColumnReference Column="Expr1008" />
                              </OutputList>
                              <StreamAggregate>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Column="Expr1008" />
                                    <ScalarOperator ScalarString="MIN([VR_SG].[dbo].[bas_Achieve].[A_Value1] as [a].[A_Value1])">
                                      <Aggregate AggType="MIN" Distinct="false">
                                        <ScalarOperator>
                                          <Identifier>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </Aggregate>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <GroupBy>
                                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                </GroupBy>
                                <RelOp AvgRowSize="21" EstimateCPU="0.000276194" EstimateIO="0" EstimateRebinds="9246.65" EstimateRewinds="0.296296" EstimateRows="10" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="16.6965">
                                  <OutputList>
                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                  </OutputList>
                                  <NestedLoops Optimized="false">
                                    <OuterReferences>
                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                    </OuterReferences>
                                    <RelOp AvgRowSize="15" EstimateCPU="0.000223" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="9246.95" EstimateRows="9.08059" LogicalOp="Clustered Index Seek" NodeId="12" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1.54743" TableCardinality="5100">
                                      <OutputList>
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                      </OutputList>
                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Index="[PK_BAS_PLAYERACHIEVE]" Alias="[b]" TableReferenceId="2" IndexKind="Clustered" />
                                        <SeekPredicates>
                                          <SeekPredicateNew>
                                            <SeekKeys>
                                              <Prefix ScanType="EQ">
                                                <RangeColumns>
                                                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                                                </RangeColumns>
                                                <RangeExpressions>
                                                  <ScalarOperator ScalarString="N'o_EJvxL2OGpqFwvPI_0tkcN-UDZc'">
                                                    <Const ConstValue="N'o_EJvxL2OGpqFwvPI_0tkcN-UDZc'" />
                                                  </ScalarOperator>
                                                </RangeExpressions>
                                              </Prefix>
                                            </SeekKeys>
                                          </SeekPredicateNew>
                                        </SeekPredicates>
                                      </IndexScan>
                                    </RelOp>
                                    <RelOp AvgRowSize="21" EstimateCPU="1.76645E-06" EstimateIO="0" EstimateRebinds="158956" EstimateRewinds="0" EstimateRows="1.10125" LogicalOp="Filter" NodeId="13" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="25.5562">
                                      <OutputList>
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                      </OutputList>
                                      <Filter StartupExpression="true">
                                        <RelOp AvgRowSize="21" EstimateCPU="0.000158983" EstimateIO="0.003125" EstimateRebinds="158956" EstimateRewinds="0" EstimateRows="1.10125" LogicalOp="Clustered Index Seek" NodeId="14" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="25.2754" TableCardinality="165">
                                          <OutputList>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                          </OutputList>
                                          <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                              </DefinedValue>
                                              <DefinedValue>
                                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                              </DefinedValue>
                                            </DefinedValues>
                                            <Object Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Index="[PK_BAS_ACHIEVE]" Alias="[a]" TableReferenceId="2" IndexKind="Clustered" />
                                            <SeekPredicates>
                                              <SeekPredicateNew>
                                                <SeekKeys>
                                                  <Prefix ScanType="EQ">
                                                    <RangeColumns>
                                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                                    </RangeColumns>
                                                    <RangeExpressions>
                                                      <ScalarOperator ScalarString="[VR_SG].[dbo].[bas_PlayerAchieve].[PA_Achieve] as [b].[PA_Achieve]">
                                                        <Identifier>
                                                          <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </RangeExpressions>
                                                  </Prefix>
                                                </SeekKeys>
                                              </SeekPredicateNew>
                                            </SeekPredicates>
                                            <Predicate>
                                              <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[VR_SG].[dbo].[bas_Achieve].[A_Value1] as [a].[A_Value1],0)&gt;[VR_SG].[dbo].[bas_PlayerAchieve].[PA_Value] as [b].[PA_Value]">
                                                <Compare CompareOp="GT">
                                                  <ScalarOperator>
                                                    <Convert DataType="int" Style="0" Implicit="true">
                                                      <ScalarOperator>
                                                        <Identifier>
                                                          <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                                        </Identifier>
                                                      </ScalarOperator>
                                                    </Convert>
                                                  </ScalarOperator>
                                                  <ScalarOperator>
                                                    <Identifier>
                                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                                    </Identifier>
                                                  </ScalarOperator>
                                                </Compare>
                                              </ScalarOperator>
                                            </Predicate>
                                          </IndexScan>
                                        </RelOp>
                                        <Predicate>
                                          <ScalarOperator ScalarString="[VR_SG].[dbo].[bas_PlayerAchieve].[PA_Player] as [b].[PA_Player]=N'o_EJvxL2OGpqFwvPI_0tkcN-UDZc'">
                                            <Compare CompareOp="EQ">
                                              <ScalarOperator>
                                                <Identifier>
                                                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                                                </Identifier>
                                              </ScalarOperator>
                                              <ScalarOperator>
                                                <Const ConstValue="N'o_EJvxL2OGpqFwvPI_0tkcN-UDZc'" />
                                              </ScalarOperator>
                                            </Compare>
                                          </ScalarOperator>
                                        </Predicate>
                                      </Filter>
                                    </RelOp>
                                  </NestedLoops>
                                </RelOp>
                              </StreamAggregate>
                            </RelOp>
                          </ComputeScalar>
                        </RelOp>
                        <Predicate>
                          <ScalarOperator ScalarString="(CONVERT_IMPLICIT(nvarchar(max),CONVERT(varchar(max),[VR_SG].[dbo].[bas_Achieve].[A_ID] as [a].[A_ID],0),0)+[VR_SG].[dbo].[bas_Achieve].[A_Value1] as [a].[A_Value1])=([Expr1016]+[Expr1008])">
                            <Compare CompareOp="EQ">
                              <ScalarOperator>
                                <Arithmetic Operation="ADD">
                                  <ScalarOperator>
                                    <Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="true">
                                      <ScalarOperator>
                                        <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="false">
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </Convert>
                                      </ScalarOperator>
                                    </Convert>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Arithmetic>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Arithmetic Operation="ADD">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Expr1016" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Expr1008" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Arithmetic>
                              </ScalarOperator>
                            </Compare>
                          </ScalarOperator>
                        </Predicate>
                      </Filter>
                    </RelOp>
                    <RelOp AvgRowSize="9" EstimateCPU="3.50406E-05" EstimateIO="0" EstimateRebinds="9246.65" EstimateRewinds="0.296296" EstimateRows="1" LogicalOp="Filter" NodeId="24" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="47.6064">
                      <OutputList />
                      <Filter StartupExpression="false">
                        <RelOp AvgRowSize="73" EstimateCPU="3.2445E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="9246.95" EstimateRows="10" LogicalOp="Compute Scalar" NodeId="25" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="47.6064">
                          <OutputList>
                            <ColumnReference Column="Expr1014" />
                            <ColumnReference Column="Expr1018" />
                          </OutputList>
                          <ComputeScalar>
                            <DefinedValues>
                              <DefinedValue>
                                <ColumnReference Column="Expr1018" />
                                <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(10),CONVERT(varchar(10),[VR_SG].[dbo].[bas_Achieve].[A_ID] as [a].[A_ID],0),0)">
                                  <Convert DataType="nvarchar" Length="20" Style="0" Implicit="true">
                                    <ScalarOperator>
                                      <Convert DataType="varchar" Length="10" Style="0" Implicit="false">
                                        <ScalarOperator>
                                          <Identifier>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </Convert>
                                    </ScalarOperator>
                                  </Convert>
                                </ScalarOperator>
                              </DefinedValue>
                            </DefinedValues>
                            <RelOp AvgRowSize="65" EstimateCPU="3.56895E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="9246.95" EstimateRows="10" LogicalOp="Aggregate" NodeId="26" Parallel="false" PhysicalOp="Stream Aggregate" EstimatedTotalSubtreeCost="47.6064">
                              <OutputList>
                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                <ColumnReference Column="Expr1014" />
                              </OutputList>
                              <StreamAggregate>
                                <DefinedValues>
                                  <DefinedValue>
                                    <ColumnReference Column="Expr1014" />
                                    <ScalarOperator ScalarString="MAX([VR_SG].[dbo].[bas_Achieve].[A_Value1] as [a].[A_Value1])">
                                      <Aggregate AggType="MAX" Distinct="false">
                                        <ScalarOperator>
                                          <Identifier>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                          </Identifier>
                                        </ScalarOperator>
                                      </Aggregate>
                                    </ScalarOperator>
                                  </DefinedValue>
                                </DefinedValues>
                                <GroupBy>
                                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                </GroupBy>
                                <RelOp AvgRowSize="21" EstimateCPU="0.0002508" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="9246.95" EstimateRows="10" LogicalOp="Inner Join" NodeId="27" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="47.6064">
                                  <OutputList>
                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                  </OutputList>
                                  <NestedLoops Optimized="false">
                                    <OuterReferences>
                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                    </OuterReferences>
                                    <RelOp AvgRowSize="15" EstimateCPU="0.000223" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="9246.95" EstimateRows="18.4928" LogicalOp="Clustered Index Seek" NodeId="28" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="1.64318" TableCardinality="5100">
                                      <OutputList>
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                      </OutputList>
                                      <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" NoExpandHint="false">
                                        <DefinedValues>
                                          <DefinedValue>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                          </DefinedValue>
                                          <DefinedValue>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                          </DefinedValue>
                                        </DefinedValues>
                                        <Object Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Index="[PK_BAS_PLAYERACHIEVE]" Alias="[b]" TableReferenceId="3" IndexKind="Clustered" />
                                        <SeekPredicates>
                                          <SeekPredicateNew>
                                            <SeekKeys>
                                              <Prefix ScanType="EQ">
                                                <RangeColumns>
                                                  <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Player" />
                                                </RangeColumns>
                                                <RangeExpressions>
                                                  <ScalarOperator ScalarString="N'o_EJvxL2OGpqFwvPI_0tkcN-UDZc'">
                                                    <Const ConstValue="N'o_EJvxL2OGpqFwvPI_0tkcN-UDZc'" />
                                                  </ScalarOperator>
                                                </RangeExpressions>
                                              </Prefix>
                                            </SeekKeys>
                                          </SeekPredicateNew>
                                        </SeekPredicates>
                                      </IndexScan>
                                    </RelOp>
                                    <RelOp AvgRowSize="21" EstimateCPU="0.0004231" EstimateIO="0.013125" EstimateRebinds="260640" EstimateRewinds="0" EstimateRows="1" LogicalOp="Eager Spool" NodeId="29" Parallel="false" PhysicalOp="Index Spool" EstimatedTotalSubtreeCost="47.6064">
                                      <OutputList>
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                      </OutputList>
                                      <Spool>
                                        <SeekPredicateNew>
                                          <SeekKeys>
                                            <Prefix ScanType="EQ">
                                              <RangeColumns>
                                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                              </RangeColumns>
                                              <RangeExpressions>
                                                <ScalarOperator ScalarString="[VR_SG].[dbo].[bas_PlayerAchieve].[PA_Achieve] as [b].[PA_Achieve]">
                                                  <Identifier>
                                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Achieve" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </RangeExpressions>
                                            </Prefix>
                                            <EndRange ScanType="LT">
                                              <RangeColumns>
                                                <ColumnReference Column="Expr1019" />
                                              </RangeColumns>
                                              <RangeExpressions>
                                                <ScalarOperator ScalarString="[VR_SG].[dbo].[bas_PlayerAchieve].[PA_Value] as [b].[PA_Value]">
                                                  <Identifier>
                                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_PlayerAchieve]" Alias="[b]" Column="PA_Value" />
                                                  </Identifier>
                                                </ScalarOperator>
                                              </RangeExpressions>
                                            </EndRange>
                                          </SeekKeys>
                                        </SeekPredicateNew>
                                        <RelOp AvgRowSize="25" EstimateCPU="1.65E-05" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="165" LogicalOp="Compute Scalar" NodeId="30" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00422074">
                                          <OutputList>
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                            <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                            <ColumnReference Column="Expr1019" />
                                          </OutputList>
                                          <ComputeScalar>
                                            <DefinedValues>
                                              <DefinedValue>
                                                <ColumnReference Column="Expr1019" />
                                                <ScalarOperator ScalarString="CONVERT_IMPLICIT(int,[VR_SG].[dbo].[bas_Achieve].[A_Value1] as [a].[A_Value1],0)">
                                                  <Convert DataType="int" Style="0" Implicit="true">
                                                    <ScalarOperator>
                                                      <Identifier>
                                                        <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                                      </Identifier>
                                                    </ScalarOperator>
                                                  </Convert>
                                                </ScalarOperator>
                                              </DefinedValue>
                                            </DefinedValues>
                                            <RelOp AvgRowSize="21" EstimateCPU="0.0003385" EstimateIO="0.00386574" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="165" LogicalOp="Clustered Index Scan" NodeId="31" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="0.00420424" TableCardinality="165">
                                              <OutputList>
                                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                                <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                              </OutputList>
                                              <IndexScan Ordered="false" ForcedIndex="false" NoExpandHint="false">
                                                <DefinedValues>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                                  </DefinedValue>
                                                  <DefinedValue>
                                                    <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                                  </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Index="[PK_BAS_ACHIEVE]" Alias="[a]" TableReferenceId="3" IndexKind="Clustered" />
                                              </IndexScan>
                                            </RelOp>
                                          </ComputeScalar>
                                        </RelOp>
                                      </Spool>
                                    </RelOp>
                                  </NestedLoops>
                                </RelOp>
                              </StreamAggregate>
                            </RelOp>
                          </ComputeScalar>
                        </RelOp>
                        <Predicate>
                          <ScalarOperator ScalarString="(CONVERT_IMPLICIT(nvarchar(max),CONVERT(varchar(max),[VR_SG].[dbo].[bas_Achieve].[A_ID] as [a].[A_ID],0),0)+[VR_SG].[dbo].[bas_Achieve].[A_Value1] as [a].[A_Value1])=([Expr1018]+[Expr1014])">
                            <Compare CompareOp="EQ">
                              <ScalarOperator>
                                <Arithmetic Operation="ADD">
                                  <ScalarOperator>
                                    <Convert DataType="nvarchar(max)" Length="2147483647" Style="0" Implicit="true">
                                      <ScalarOperator>
                                        <Convert DataType="varchar(max)" Length="2147483647" Style="0" Implicit="false">
                                          <ScalarOperator>
                                            <Identifier>
                                              <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_ID" />
                                            </Identifier>
                                          </ScalarOperator>
                                        </Convert>
                                      </ScalarOperator>
                                    </Convert>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Database="[VR_SG]" Schema="[dbo]" Table="[bas_Achieve]" Alias="[a]" Column="A_Value1" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Arithmetic>
                              </ScalarOperator>
                              <ScalarOperator>
                                <Arithmetic Operation="ADD">
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Expr1018" />
                                    </Identifier>
                                  </ScalarOperator>
                                  <ScalarOperator>
                                    <Identifier>
                                      <ColumnReference Column="Expr1014" />
                                    </Identifier>
                                  </ScalarOperator>
                                </Arithmetic>
                              </ScalarOperator>
                            </Compare>
                          </ScalarOperator>
                        </Predicate>
                      </Filter>
                    </RelOp>
                  </Concat>
                </RelOp>
              </NestedLoops>
            </RelOp>
          </QueryPlan>
        </StmtSimple>
      </Statements>
    </Batch>
  </BatchSequence>
</ShowPlanXML>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

3条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
Tsui丶 2017-09-29 07:21
关注
http://blog.csdn.net/csdnstudent/article/details/40398245 sql优化

http://database.51cto.com/art/201108/284820.htm 多表查询优化
参考下吧

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(2条)

报告相同问题？

关注问题

SQL语句优化,SQL语句性能优化,改写求助 sql
2017-09-29 06:13

回答 3 已采纳 http://blog.csdn.net/csdnstudent/article/details/40398245 sql优化 http://database.51cto.com/art/2
拦截并修改某个sql语句(mybatisplus篇) intellij-idea java
2022-11-07 14:46

回答 3 已采纳可以参考Mybatis的拦截器 @Intercepts mybatisplus的拦截器示例参考mybatis plus中的源码（QueryInterceptor）： @Intercepts(
Mybatis如何改写带标签的SQL java sql
2022-03-31 17:00

回答 5 已采纳绝大部分的改写sql，都是在原有sql上变更，所以插件就行了，而你的需求是不通过xml，自己定义便签内的sql片段，插件那就不合适了，而mybatis 3引入注解以后，提供了SelectProvide
sql语句优化之用EXISTS替代IN、用NOT EXISTS替代NOT IN的语句
2021-01-19 22:32

在许多基于基础表的查询中,为了满足一个条件,往往需要对另一个表进行联接。... 如我要查询 Sendorder表中的冗余数据（没有和reg_person或worksite相连的数据） sql=”select Sendorder.id,Sendorder.reads,Sendor
一个关于sparksql语句的问题 spark sql 大数据有问必答
2023-01-19 12:45

回答 2 已采纳把round函数改成round(AVG(price),2)试试,
以下语句在access中应如何改写？ sql
2017-09-06 03:00

回答 1 已采纳 access不支持子查询，没办法改写。低效的办法是借助中间表。
oracle的sql改成mysql版本 mysql oracle sql
2022-07-26 16:49

回答 2 已采纳 select sum(ifnull(is_this_month,0)) total, sum(ifnull(is_this_month,0)) - sum(ifnull(i
解决Oracle SQL语句性能问题——SQL语句改写（视图、标量子查询及update）
2023-08-29 11:00

lhdz_bj的博客本文详细说明了解决Oracle SQL性能问题的方法——SQL语句改写（视图、标量子查询及update），同时，结合实例对其进行了深入讲解。
Oracle中如何用SQL筛选出同一时间食用两种或以上水果的姓名 oracle sql
2023-01-18 21:57

回答 7 已采纳你的思路是正确的，但是你的语句有一些问题。首先，你在 with a as 中使用了表名为 table，你需要更改为实际的表名。其次，在 with b as 中，你使用了 t1.frute 和 t2
用sql语句在access中如何删除自动编号的那一行
2016-02-21 04:51

回答 1 已采纳 ``` String sql = "delete from tb_poll where ID="+index; ```
这段代码可以改写成group by...having语句吗?如果能,怎么改? sql
2015-12-08 09:58

回答 4 已采纳 SELECT empfname, empsalary FROM qemp GROUP BY empsalary HAVING empsalary > 90*AVG(empsalary);
SQL语句优化的30种方法，总结的太棒了
2022-07-06 09:16

biyusr的博客 1、对查询进行优化，应尽量避免全表扫描，首先应考虑在 where 及 order by 涉及的列上建立索引。2、应尽量避免在 where 子句中使用!=或操作符，否则将引擎放弃使用索引而进行全表扫描。3、应尽量避免在 where 子句中...
如何用MySQL查询在2019年3月注册的用户，在往后的一年时间（按月），的活跃或流失情况——生命周期 mysql sql
2020-04-13 23:55

回答 1 已采纳 SELECT SUBSTR(a.created_at,1,7),COUNT(1) FROM tab_user a LEFT OUTER JOIN tab_action b ON a.user
SQL语句优化的30种方法
2022-07-14 11:43

Gan_1314的博客 SQL语句优化
SQL语句的优化方法
2022-09-15 11:43

佳德_Boy的博客 SQL语句的优化方法
没有解决我的问题, 去提问

悬赏问题

¥15 (标签-UDP|关键词-client)
¥15 关于库卡officelite无法与虚拟机通讯的问题
¥15 qgcomp混合物线性模型分析的代码出现错误：Model aliasing occurred
¥100 已有python代码，要求做成可执行程序，程序设计内容不多
¥15 目标检测项目无法读取视频
¥15 GEO datasets中基因芯片数据仅仅提供了normalized signal如何进行差异分析
¥100 求采集电商背景音乐的方法
¥15 数学建模竞赛求指导帮助
¥15 STM32控制MAX7219问题求解答
¥20 在本地部署CHATRWKV时遇到了AttributeError: 'str' object has no attribute 'requires_grad'

SQL语句优化,SQL语句性能优化,改写求助

3条回答 默认 最新

悬赏问题

3条回答默认最新