All Questions
Tagged with indexed sql-server
10 questions
0
votes
0
answers
189
views
Create indexed view that contains text columns
I require to create an indexed view in SQL Server. Two tables are inner joined in this view.
Both tables also contain text columns. The view index is created on an index column of table1.
CREATE ...
- 11
3
votes
1
answer
4k
views
SQL Server Indexed Views vs Oracle Materialized View
I know materialized view and I'm using it. I have never used indexed views but I will. What are the differences between them ?
0
votes
1
answer
135
views
Indexed View looking for null references without INNER JOIN or Subquery
So I have a legacy database with table structure like this (simplified)
Create Table Transaction
{
TransactionId INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
ReplacesTransactionId INT
..
.....
23
votes
5
answers
42k
views
What to replace left join in a view so i can have an indexed view?
I have normalized tables in a database and to denormalize it, I created a view out of two tables. When I tried to create a clustered index on the view, it wouldn't let me, as the view was created with ...
2
votes
1
answer
1k
views
SQL Server 2008 R2 and execution plan in the indexed view
I've created an indexed view (MyView) that consists of three columns:
Table1_ID (int not null)
Object_CreationDate (datetime, null)
Objec_Count(bigint null)
I have created clustered unique index ...
- 1,020
0
votes
1
answer
1k
views
Problem with creating Indexed View AND Group BY in SQL Server 2008 R2
I want to create indexed view with such t-sql:
Select
Table1_ID,
cast(CONVERT(varchar(8),
t2.Object_CreationDate, 112)AS DateTime) as Object_CreationDate ,
Count_BIG(*) as ...
- 1,020
1
vote
2
answers
2k
views
Understanding indexed view update qnd query process in SQL Server 2008 R2
I created indexed view (clustered unique index on Table1_ID) view with such T-SQL:
Select Table1_ID, Count_BIG(*) as Table2TotalCount from Table2 inner join
Table1 inner join... where ...
- 1,020
1
vote
2
answers
601
views
Understanding column type in indexed view in SQL Server 2008 R2
We created an indexed view by such sql:
Select Table1_ID, Count_BIG(*) as Table2TotalCount from Table2 inner join
Table1 inner join... where...
Also after creating the view, we set clustered unique ...
- 1,020
5
votes
8
answers
2k
views
Re-indexing large table - how screwed am I?
I have a 1 TB, 600m row, table which has a misguided choice of indexed columns, specifically a clustered index on the primary key column which is never used in a select query.
I want to remove the ...
- 27k
2
votes
2
answers
1k
views
Indexed Views in OLTPs?
I'm familiar with SQL Server Indexed Views (or Oracle Materialized Views), we use them in our OLAP applications. They have the really cool feature of being able to usurp an execution plan and remap it ...
- 3,200