# Lab 6

## Student information

* Full name:
* E-mail:
* UCR NetID:
* Student ID:

## Answers

* (Q1) What are these two arguments?


* (Q2) What is the type of the attributes `time` and `bytes` this time? Why?

* (Q3) Record sizes and report in README ane explain why?


* (Q4) How many jobs does your program have? List them here, and describe what each job is performing.


* (Q5) How many stages does your program have? Why does it have two stages for the countByKey job?


* (Q6) What are the longest two stages? Why do you think they are the longest?


* (Q7) Copy the output of the command including the code, and Avg(bytes) table, as well as the runtime.


* (Q8) How many jobs does your program have? List them here, and describe how they compare to the previous program.



* (Q9) How many stages does your program have? How did the number of stages affect the run time? Is this program slower or faster?


* (Q10) Visit this link [http://localhost:4040/SQL](http://localhost:4040/SQL), on that page click on the `collect at AppSQL`. Observe the graph which represents how your query was processed. Then, scroll to the end of bottom of the page, and click on `> Details`. You will notice two parts `+- == Final Plan ==` and `+- == Initial Plan ==`. Copy those plans here, and discuss. Which plan is longer and more complicated? Which plan do you think is more optimal?