You want to do an equality search looking for all people


Problem Assumptions:

There are 20,000 blocks on the CSC342.Person table file.

The table file is structured as a Heap file.

There is a ‘Last_Name' index on the table

The index has 4 levels.

It takes 1 millisecond to read a block from disk.

There is one person row with the last name = 'DePratti'

You want to do an equality search looking for all people with the last_name = ‘DePratti'.

How long will it take to find the block with the DePratti row?

Choose one from below

5 ms

4 ms

10 ms

20 ms

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: You want to do an equality search looking for all people
Reference No:- TGS02897413

Expected delivery within 24 Hours