如何在sql server 2008中优化以下查询。我需要优化的特殊select查询。@@ERROR SELECT top 1 @tokenSeqNo=S_NO,@pmtAcctToken = PMT_ACCT_TOKEN, @proxyAcctToken=PROXY_PMT_TOKEN
FROM PCTransDB.dbo.MIG_TOKEN_DUMP WHERE CONSUMED_FLAG= &
我在Spring JdbcTokenStore上遇到了糟糕的性能,所以我做了一些调查,发现以下查询速度很慢:
delete from oauth_access_token where token_idselect token_id, authentication from oauth_access_token where token_id = ?select token_id, token from oauth_access_token where a