Tags » Partitioning

Yeah, a new one in my stupid linux fails mid-night. I was just installing Gentoo and wanting to prepare my disk. Well at first I did everything right, but then I wanted to correct something and started… 118 more words


Partial Indexes Trilogy - Part 3: Queries on Partial Indexes

After creating local and global partial indexes, the last part of this blog post trilogy shows how partial indexes are used by the optimizer for SQL queries – especially for queries in Data Warehouse environments. 2,638 more words



A neuro-evolution method for dynamic resource allocation on a chip multiprocessor (paper)
Neural network를 사용해 CMP에서 각 코어에 대한 캐시 할당량을 결정하고자 하는 논문이다. 22 more words

1) Memo

Partial Indexes Trilogy - Part 2: Global Partial Indexes

Partial Indexes, introduced with Oracle 12c, are available for local and global indexes. In part 2 of this blog post trilogy, let’s focus on global partial indexes on a partitioned table. 1,899 more words


DML and Bloom

One of the comments on my recent posting about “Why use pl/sql bulk strategies over simple SQL” pointed out that it’s not just distributed queries that can change plans dramatically when you change from a simple select to… 1,125 more words



확인해보니 지금껏 진행하던 연구와 비슷한 연구도 ATC’16에 발표되었다(Ginseng: Market-Driven LLC Allocation). Motivation만 있었을 뿐 구체적인 아이디어가 없었기에 그렇게 아쉽지는 않지만, 그래도 내가 놓친 부분들이 분명히 있었던 것 같다. 14 more words

1) My Story

Partial Indexes Trilogy - Part 1: Local Partial Indexes

Sometimes it would be useful to create indexes for only some of the partitions of a partitioned table. Oracle 12c supports this possibility with Partial Indexes. 1,565 more words