---++Faceted Browser Pre-Installation
Run the following commands using the Virtuoso isql
program before installing the Faceted Browser VAD:
DROP INDEX RDF_QUAD_OPGS;
DROP INDEX RDF_QUAD_POGS;
DROP INDEX RDF_QUAD_GPOS;
DROP INDEX RDF_QUAD_OGPS;
CHECKPOINT;
CREATE TABLE R2
( G iri_id_8 ,
S iri_id_8 ,
P iri_id_8 ,
O ANY ,
PRIMARY KEY (S, P, O, G)
);
ALTER INDEX R2
ON R2
PARTITION ( S INT (0hexffff00) );
LOG_ENABLE (2);
INSERT INTO R2 (G, S, P, O)
SELECT G, S, P, O
FROM rdf_quad;
DROP TABLE RDF_QUAD;
ALTER TABLE R2
RENAME RDF_QUAD;
CHECKPOINT;
CREATE BITMAP INDEX RDF_QUAD_OPGS
ON RDF_QUAD (O, P, G, S)
PARTITION ( O VARCHAR ( -1, 0hexffff ) );
CREATE BITMAP INDEX RDF_QUAD_POGS
ON RDF_QUAD (P, O, G, S)
PARTITION ( O VARCHAR ( -1, 0hexffff ) );
CREATE BITMAP INDEX RDF_QUAD_GPOS
ON RDF_QUAD (G, P, O, S)
PARTITION ( O VARCHAR ( -1, 0hexffff ) );
CHECKPOINT;