You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
- AMERGE
- BSELECT …CROSS JOIN
- CINSERT ALL …SELECT
- DCREATE VIEW …CONSTRAINT