Without LOCAL, LOAD DATA is _________________
(a) less efficient
(b) more efficient
(c) same speed
(d) arbitrary
(a) less efficient
(b) more efficient
(c) same speed
(d) arbitrary
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
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.