You have not shared your DDL, so that it will be specific.
You can see it using explain. The best one to explain is the Optimzer :)
You can have a look at this post. It may be of your interest.It talks about SI though.