StackOverflow Questions for Tag: indexed-views

coryseaman

Reputation: 388

Greatest value in group solution that also meets requirements for indexed view

sql-serverpivotfull-text-searchgreatest-n-per-groupindexed-view

Score: 0

Answers: 1

Attaf

Reputation: 1

Is there a way to find out which records have changed in an indexed view?

sql-serverindexed-view

Score: -1

Answers: 2

Paul de Roos

Reputation: 77

SQL Server: Materialized view based on stored proc with dynamic sql - how to

sqlsql-serverstored-proceduresdynamic-sqlindexed-view

Score: 0

Answers: 0

dopoto

Reputation: 1274

Error when creating view - [dbo].[someFunction] is not schema bound

sql-server-2008indexed-views

Score: 5

Answers: 1

Venkataraman R

Reputation: 13009

Multiple composite index vs single non-clustered column store index

sql-servernon-clustered-indexcolumnstoreindexed-viewazure-sql-managed-instance

Score: 0

Answers: 1

r34

Reputation: 332

SQL Server - indexed view with string_agg

sql-serverindexed-viewstring-agg

Score: 1

Answers: 2

user3339793

Reputation: 13

Performance issues with inserting records into a table used by indexed views?

sqlsql-serverindexed-view

Score: 1

Answers: 1

Mazhar

Reputation: 3837

TSQL Cannot create index on view - the view uses an implicit conversion from string to datetime

t-sqlviewsql-server-2008-r2indexed-view

Score: 1

Answers: 2

JavaLearner

Reputation: 647

Updating underlying tables of indexed view but the column is not present in the view

sqlsql-servert-sqlviewindexed-view

Score: 0

Answers: 1

Ben H

Reputation: 26

indexed view update is table scanning 110 million rows for 6 actual rows found out of histogram key bounds

sql-serverhistogramdatabase-administrationindexed-viewfull-table-scan

Score: 1

Answers: 2

Pure.Krome

Reputation: 87047

How can i speed up this Indexed View?

sqlsql-servert-sqlsql-server-2008indexed-view

Score: 13

Answers: 7

Massoud Beygi

Reputation: 15

Use Sum on extra aggregation and Make Total

sql-serversumindexed-view

Score: 0

Answers: 2

Andy

Reputation: 31

Indexed View w Business Logic

sqlsql-serverindexed-view

Score: 1

Answers: 0

DJElie

Reputation: 1

Add an index in view if it is simply a simple select on one table. No joins

sql-serverviewindexed-view

Score: 0

Answers: 0

Robert Wolf

Reputation: 301

Makes it sense to create an indexed view when the data is frequently changed?

sql-serverindexed-view

Score: 0

Answers: 1

Mihail Shishkov

Reputation: 15887

Querying a view after creating a clustered index on it still yields the same query plan

sqlsql-serversql-server-2017clustered-indexindexed-view

Score: 2

Answers: 1

ParoX

Reputation: 5941

How to create indexed view of children count

sqlsql-servert-sqlcommon-table-expressionindexed-view

Score: 4

Answers: 3

Jeff

Reputation: 36583

SQL Server Indexes INSERT/UPDATE Performance

databasesql-server-2008database-performanceindexed-view

Score: 2

Answers: 1

Fractaliste

Reputation: 5957

When is an indexed view updated?

sql-serverindexed-view

Score: 6

Answers: 1

Icarus

Reputation: 455

Can I use an indexed view in SQL Server to fetch only non duplicate records

sql-serverduplicatesindexed-view

Score: 1

Answers: 1

PreviousPage 2Next