The EXPLAIN command will fail if you use it for other SQL commands, such as data definition language (DDL) or database operations. The EXPLAIN output relative unit costs are used by Amazon Redshift to choose a query plan. Amazon Redshift compares the sizes of various resource estimates to ...
it is used basically to insert update operationas on table. means it is used for execution of DML commands e.g sqlcommand cmd=new sqlCommand("insert into emp values ('1','2'",con); con.open(); cmd.ExecuteNonquery(); 0 Most Popular Job Functions Developer (2386) Programmer (1288)...
1. Explain the difference between the following SQL commands: GRANT SELECT ON EMPLOYEE TO user1 GRANT SELECT ON EMPLOYEE TO user1 WITH GRANT OPTION 2. Describe the shadow paging recovery technique. Un What is the difference between a databa...