Skip to content

scan

Oracle 21c : Two nodes Grid Infrastructure Installation

By Mouhamadou Diaw Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below the addresses I am using. Note that a dns server is setup 1 2 3 4 5 6 192.168.0.101 racp1vm1.dbi.lab racp1vm1            –public network 192.168.0.103… 

DynamoDB Scan: the most efficient operation 😉

By Franck Pachot . The title is provocative on purpose because you can read in many places that you should avoid scans, and that Scan operations are less efficient than other operations in DynamoDB. I think that there is a risk, reading those message without understanding what is behind, that people will actually avoid Scans and replace them by something… 

DynamoDB Scan (and why 128.5 RCU?)

By Franck Pachot . In the previous post I described the PartiSQL SELECT for DynamoDB and mentioned that a SELECT without a WHERE clause on the partition key may result in a Scan, but the result is automatically paginated. This pagination, and the cost of a Scan, is something that may not be very clear from the documentation and I’ll… 

RDBMS (vs. NoSQL) scales the algorithm before the hardware

By Franck Pachot . In The myth of NoSQL (vs. RDBMS) “joins dont scale” I explained that joins actually scale very well with an O(logN) on the input tables size, thanks to B*Tree index access, and can even be bounded by hash partitioning with local index, like in DynamoDB single-table design. Jonathan Lewis added a comment that, given the name…