Hi Sumit,
NULL indicates is it a row wise table, which would have been a result of
upgrading a v6 database to v7. Note, just using a v7 binary will not result in
a table being converted to column wise, it will remain in he format it was
found which is why the instructions for converting from r
Thanks Hugh for prompt response.
mine has neither "row" or "column" but "NULL" . what does this mean ?
DB.DBA.RDF_QUAD
NULL
DB.DBA.RDF_QUAD
vector ('distinct', 'no_
Hi Summit/Bart,
The sys_keys table can then be queried to verify if the index type of the table
is column, row (index, or bitmap) wise:
SQL> SELECT TOP 10 KEY_TABLE, sys_sql_val_print (KEY_OPTIONS)
FROM sys_keys
WHERE KEY_TABLE = 'DB.DBA.RDF_QUAD' ;
KEY_TABLE sys_sql_va
I +1 Bart's question as I also want to know which tables are using latest
column store.
Is there a way ?
Thanks
Sumit Purohit
-Original Message-
From: Bart Vandewoestyne [mailto:bart.vandewoest...@telenet.be]
Sent: Tuesday, May 20, 2014 4:50 AM
To: virtuoso-users@lists.sourceforge.ne
On 2014-05-18 16:11, Hugh Williams wrote:
> Hi Sumit
>
> Ah, didn't realise you started with a v6 row store database, thus how
> did you upgrade to v7 ?
>
> As if you simply check pointed and restarted the v6 database with a v7
> binary then it would be automatically upgraded but all the tables
> i
Hi Hugh,
the "rc2" version is 7.0.0-rc2.3203 (SHA =
48f0ef879b913c5d3b306c1f83390079c5416fe6), while the "latest" is
7.1.1-dev.3208-pthreads (SHA = 32bc49a3368dc2303e3e4f0825752790f86de867).
Do you think that, rather than reloading the triples (which would take a
while), using DB.DBA.VT_INDEX_DB_
