What modification does Magento_Staging make to existing SQL queries?

You are working on a project with a large database with many products, sales rules and CMS pages. The merchant is going to use Magento_Staging for scheduled updates, but they were told that use of Staging will modify all SQL queries and slow down website performance.

What modification does Magento_Staging make to existing SQL queries?
A . It creates a copy of the staged table with the staged data and joins the new table to replace original values with the staged ones
B. Every query which uses staged entities will have an additional join to the staging_update table filtered by the current version
C. Magento.staging does not modify any existing queries so it has no additional impact
D. For every query that uses staged entities it adds an additional were statement to filter a row by the current version

View Answer

Answer: D