Month: September 2021

Single block i/o and Multi block i/o

Whenever we are doing single block i/o on a table which is having index, the optimizer only has to traverse through the root—-branch—leaf and it will do a random i/o on the block address which […]

 514 total views