On 2014-05-21 00:03, Hugh Williams wrote:
> 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_val_print
> VARCHAR NOT NULL VARCHAR
> _______________________________________________________________________________
>
> DB.DBA.RDF_QUAD vector ('column')
> DB.DBA.RDF_QUAD vector ('distinct', 'no_pk', 'column', vector
> (525, 0, 0, '__ALL', vector (vector (0, 'S', 1, 16776960, 0))))
> DB.DBA.RDF_QUAD vector ('distinct', 'no_pk', 'column', vector
> (525, 0, 0, '__ALL', vector (vector (0, 'O', 3, -1, 65535))))
> DB.DBA.RDF_QUAD vector ('column', vector (525, 0, 0, '__ALL',
> vector (vector (0, 'O', 3, -1, 65535))))
> DB.DBA.RDF_QUAD vector ('distinct', 'no_pk', 'column', vector
> (525, 0, 0, '__ALL', vector (vector (0, 'S', 1, 16776960, 0))))
>
> 5 Rows. -- 1 msec.
> SQL>
>
> as indicated in the tip initially provided at:
>
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksRowToColStoreConversion
Hugh,
I had seen the documentation at
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksRowToColStoreConversion
but it was (and still is) not completely clear to me how to interpret
this output.
The above query returns 5 rows that all have to do with the RDF_QUAD
table. For each row, I somehow see what options are in effect... But
what do these 5 rows stand for? And how to interpret the given options?
I understand that SYS_KEYS is some kind of system table, but I cannot
find sys_sql_val_print nor KEY_OPTIONS anywhere in the documentation, so
it's hard to deduce what that info stands for.
Kind regards,
Bart
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
