DBMSImplemJoinCost

Table Order has 10.000 records, 10 record/page, Table OrderDetails has 1.000.000 records, 20 records/page. Hash join between these tables has cost:

• 153.000

• 50.000

• 1000

• 3000

Table Orders has 10.000 records, 10 record/page, Table OrderDetails has 1.000.000 records, 20 records/page. The system uses 102 frames in buffer pool to process the block nested loop join between these tables. The cost is:

• 501.000

• 50.000

• 51.000

• 550.000

Table Order has 10.000 records, 10 record/page, Table OrderDetails has 1.000.000 records, 20 records/page. Tables are sorted on join attribute. Merge join between these tables has cost:

• 51.000

• 50.000

• 1.000

• 6.000

Table Order has 10.000 records, 10 record/page, Table OrderDetails has 1.000.000 records, 20 records/page. Table OrderDetails has clustered B+ tree index on OrderID (the join attribute). Indexed nested loop join between these tables has cost:

• 81.000

• 50.000

• 51.000

• 510.000

Table OrderDetail has 1.000.000 records, there are 10.000 different products uniformly distributed. Order table has 10.000 records. How many rows will have the result of the above query.

• 10.000

• 100

• 1.000.000

Table OrderDetail has 1.000.000 records, Order table has 10.000 records there are 500 different customers uniformly distributed. How many rows will have the result of the above query.

• 100

• 20

• 2.000

• 10.000