Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]

Categories
Database Development

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

I’m doing some testing of columnstore indexing on a single table that has about 500 million rows. The performance gains on aggregate queries have been awesome (a query that previously took about 2 minutes to run now runs in 0 seconds to aggregate the entire table). But I also noticed another test query that leverages […]