Re: Which processors run SIMD to take advantage of Oracle 12c in memory option parallel processing

From: joel garry <joel-garry_at_home.com>
Date: Mon, 25 Aug 2014 10:51:06 -0700 (PDT)
Message-ID: <bfe5dc8a-55f0-47fe-b2f9-fb1373ab7cfc_at_googlegroups.com>


On Monday, August 25, 2014 4:53:07 AM UTC-7, zigz..._at_yahoo.com wrote:

>
> . Use SIMD to apply filter predicates
>
>
>
> For the IMCU that need to be scanned Oracle takes advantage of SIMD vector processing (Single Instruction processing Multiple Data values). Instead of evaluating each entry in the column one at a time, SIMD vector processing allows a set of column values to be evaluated together in a single CPU instruction. The column format used in the IM column store has been specifically designed to maximize the number of column entries that can be loaded into the vector registers on the CPU and evaluated in a single CPU instruction. SIMD vector processing enables the Oracle Database In-Memory to scan billion of rows per second per core versus the millions of rows per second per core scan rate that can be achieved in the buffer cache.

Maria tweets, why don't you ask her?

jg

-- 
_at_home.com is bogus.
http://arstechnica.com/tech-policy/2014/08/oregon-attorney-general-sues-oracle-for-racketeering-activity/
Received on Mon Aug 25 2014 - 19:51:06 CEST

Original text of this message