Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: clustering
Attribute clustering….super cool
I’ve spoken about attribute clustering before here, here and here. So from that you can probably glean that I’m a fan. I recently spoke about an example of this as well during my AskTOM Office Hours session which you can watch below: After posting…
Attribute clustering (part 3)
So in part1 and part2, we looked at creating tables with clustered data. If you’re ready to climb aboard the attribute clustering heading toward Fastville you might want to take an existing table and cluster it. In part 2 we saw how we had…
Attribute clustering (part 2)
In the previous post, I demonstrated attribute clustering by creating a table of source data which contained data in randomised order, via SQL> create table source_data as 2 select d.* 3 from dba_objects d 4 where object_id is not null 5 order by dbms_random.random;…
Attribute clustering (part 1)
One of the nice facilities in 12c is the ability to instruct the database to co-locate data during loading in order to facilitate reduced resource consumption for subsequent queries. Here’s an example of it in use. First I’ll create table SOURCE_DATA to mimic some…
