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
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 20 May 2014, at 22:35, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
> 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.net
> Subject: Re: [Virtuoso-users] Using column store structure for exiting data
>
> 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
>> including the RDF_QUAD tables and indexes would remain in the original
>> row store mode.
>
> I have a question related to this: suppose you are given a database and you
> don't know (or don't remember anymore) whether that data was created with a
> v6 or v7 version of Virtuoso. How can you then check what tables/indexes
> (and for my case, more specifically the RDF_QUAD table) are already stored
> column-wise, and which ones are still stored row-wise?
>
> 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
>
> ------------------------------------------------------------------------------
> "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
------------------------------------------------------------------------------
"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
