問題文
A long lived script relies on implicit conversion between a character column and numeric literals. A reviewer wants the conversions written out. Which pair of benefits does writing them out bring?
選択肢
- The statement runs faster in every case and the conversions are cached so that later rows reuse the work of the earlier ones.
- The direction of each conversion becomes visible in the text and the behavior stops depending on the settings of the session that runs it.
- The direction of each conversion becomes visible in the text and the values are checked before the statement is sent off to the server.
- The column becomes usable by an index in every case and the plan stops changing when the data in the table grows over time.