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 | |
---|