The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
53 views

How can we get the table and the column name of known data value?

I have a value (like 'IT department'), based on this I want to get the table and column name in which this value exists/present.
2
votes
0answers
291 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
28 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
29 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
30 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 ...