![]() ![]() The performance of the EXPLAIN statement is mostly affected by the factor of the time taken for the creation of the temporary tables.These statements can only include the Data manipulation commands such as UPDATE, INSERT, SELECT, DELETE or CREATE TABLE and cannot include any other query statements related to Data Definition Language. statement to be analyzed/query: This can be any of the SQL statements that need to be calculated, analyzed, and studied and will be considered by the explain command for retrieving the query plan of the statement query specified here. ![]() In case, if you will specify this optional parameter here in syntax named VERBOSE then the command will retrieve the detailed step-by-step information of all the steps that will be carried out by query statement execution instead of just short summary of the query plan. VERBOSE: Usually, for whichever query statement you specify in the EXPLAIN command the command only returns a summarized form of explanation that specifies all the steps of the execution flow in short.In the above syntax the terminologies that are used are given here: The below statement shows the syntax of EXPLAIN command in Redshift.ĮXPLAIN statement to be analyzed/query ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |