Question 10.10 . ( TCO 4 ) Assume you have two queries . The first query selects its data using a join involving five tables . The second query selects its data using a join involving three tables . Which of the queries would run faster , all other things being equal ? ( Points : 5 )
The first query will run slower than the second query . The second query will run slower than the second query . The queries will run at the same speed . All of the above
Question 11.11 . ( TCO 4 ) Assume you have two select queries that must join two tables . The first query uses the INNER JOIN keyword , while the other accomplishes the join using the WHERE clause . Which query will be more likely to run faster - the first query or the second query ? ( Points : 5 )
The first query will run slower than the second query . The second query will run slower than the first query . The queries will run at the same speed . All of the above