⟩ Explain When does the optimizer consider a hash based table scan on an APL table?A. if it is a heap tableB. if it is has a clustered indexC. If it is a table with a clustered index and a non clustered indexD. If it is a partitioned table with a clustered index