How fetching a row happens in Exadata [message #619724] |
Thu, 24 July 2014 13:28 |
|
superviks
Messages: 1 Registered: July 2014 Location: Hyderabad
|
Junior Member |
|
|
Hello Experts!!!
Good Day.
Suppose there is a Half-Rack Exadata machine with 4 DB and 7 Storage Nodes (Cells).
Suppose we issue a SELECT statement to query few rows of a table. My curiosity is how would the DB/Storage know exactly which cells to look for to fetch the queried rows without having to search all the 7 cells whether smart scan is being used or whether it isn't.
Warm Regards,
Vikram.
|
|
|