| 1 | drop index RDF_QUAD_OPGS; |
|---|
| 2 | drop index RDF_QUAD_POGS; |
|---|
| 3 | drop index RDF_QUAD_GPOS; |
|---|
| 4 | drop index RDF_QUAD_OGPS; |
|---|
| 5 | |
|---|
| 6 | checkpoint; |
|---|
| 7 | |
|---|
| 8 | create table R2 (G iri_id_8, S iri_id_8, P iri_id_8, O any, primary key (S, P, O, G)); |
|---|
| 9 | alter index R2 on R2 partition (S int (0hexffff00)); |
|---|
| 10 | |
|---|
| 11 | log_enable (2); |
|---|
| 12 | |
|---|
| 13 | insert into R2 (G, S, P, O) select G, S, P, O from rdf_quad; |
|---|
| 14 | |
|---|
| 15 | drop table RDF_QUAD; |
|---|
| 16 | alter table r2 rename RDF_QUAD; |
|---|
| 17 | |
|---|
| 18 | checkpoint; |
|---|
| 19 | |
|---|
| 20 | create bitmap index RDF_QUAD_OPGS on RDF_QUAD (O, P, G, S) partition (O varchar (-1, 0hexffff)); |
|---|
| 21 | create bitmap index RDF_QUAD_POGS on RDF_QUAD (P, O, G, S) partition (O varchar (-1, 0hexffff)); |
|---|
| 22 | create bitmap index RDF_QUAD_GPOS on RDF_QUAD (G, P, O, S) partition (O varchar (-1, 0hexffff)); |
|---|
| 23 | create bitmap index RDF_QUAD_OGPS on RDF_QUAD (O, G, P, S) partition (O varchar (-1, 0hexffff)); |
|---|
| 24 | |
|---|
| 25 | checkpoint; |
|---|
| 26 | |
|---|
| 27 | grant select on DB.DBA.RDF_QUAD to "SPARQL"; |
|---|
| 28 | |
|---|
| 29 | RDF_OBJ_FT_RULE_ADD (null, null, 'All'); |
|---|
| 30 | DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ (); |
|---|
| 31 | |
|---|
| 32 | checkpoint; |
|---|
| 33 | |
|---|
| 34 | grant EXECUTE ON DB.DBA.SPARQL_INSERT_DICT_CONTENT to "SPARQL"; |
|---|
| 35 | grant EXECUTE ON DB.DBA.SPARQL_DELETE_DICT_CONTENT to "SPARQL"; |
|---|
| 36 | |
|---|
| 37 | checkpoint; |
|---|
| 38 | |
|---|