A.truncate 命令不記錄日志 B.truncate 命令記錄日志 C.delete命令不記錄日志
A.select col1,col2,col3 from T1 into T2(col1,col2,col3) B.insert T1 (col1,col,col3) into T2(col1,col2,col3) C.insert into T2 (col1,col2,col3) as select col1,col2,col3 from T1 D.insert into T2(col1,col2,col3) select col1,col2,col3 from T1;
已知表tbl中字段land_ID建有索引,字段cust_id建有唯一索引,下列語句查詢邏輯相同,其中執(zhí)行效率最優(yōu)的是()
A.A B.B C.C D.D