Question

Without LOCAL, LOAD DATA is _________________

(a) less efficient

(b) more efficient

(c) same speed

(d) arbitrary

I got this question by my school principal while I was bunking the class.

I would like to ask this question from MySQL Components in portion MySQL Administration of MySQL

Answer 1

The correct choice is (b) more efficient

The explanation is: LOAD DATA is more efficient without LOCAL. Without LOCAL, the file must be located on the server. The FILE privilege must be given. The server can read the file directly from disk.