Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exadata- Columnar database?

765115Jul 24 2012 — edited Oct 1 2012
While I was reading about "smart scan" in Exadata I noticed a mention that while processing a query, only the columns needed by the query are actually returned from the storage server to the database server.

Just wondering how this is achieved- I know that Exadata is not a columnar database and stores the data as rows in tabular format in the disk. Given this, does the storage software retrieve the full row (all columns), discards the unwanted columns and returns the rest to the database? Is this how this is achieved?

I'm evaluating a columnar database and wanted to see how Exadata was able to offer the same benefit of a columnar database but with row storage in the disks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2012
Added on Jul 24 2012
3 comments
774 views