The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
283 views

Best Practice to update columnstore indexed tables

I have a table with aprox. 22 Bn rows, for each month I have made one partition that and each partition has two data files. I created the columnstore index on this table and the performance ...
0
votes
0answers
14 views

Columnstore Index Scan Cardinality Estimates

In SQL Server 2012, I am seeing large cardinality estimate discrepancies for a columnstore index scan. It looks like statistics have been generated for the index, but I don't see any details in DBCC ...
0
votes
0answers
23 views

Oracle In-Memory POPULATE_STATUS does not change to completed

I'm experimenting with the Oracle In-memory options for BI purposes, when I'm trying to populate one table to in-memory in the v$im_segments the POPULATE_STATUS does not change to completed, for other ...
0
votes
0answers
27 views

Greenplum database storage model for time series data

I have to deploy a greenplum database for analysis of time series data. I will have around 50 different time series (s1,s2,s3,...s50) and each series will have multiple pairs (time is 1 hour average ...