需要调整查询以提高性能

问题描述

我有3张桌子a，b，c.

Hi,

I have 3 table a,b,c.

select * from a

 select * from b where aid in (select id from a)

 select * from c where bid in (select Id from b where aid in (select id from a))

这些在sp中的查询并给出正确的结果，但是作为性能，我需要优化这些
你能建议我如何提高性能.是可用于优化的任何工具吗?
sql查询

感谢

these quries in sp and giving correct result but as performance I need to optimise these
could you please suggest how do i improve perfomance. is any tools available to optimised
sql queries

Thanks

推荐答案

这篇关于需要调整查询以提高性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！