Questions tagged [indexed-views]
20 questions
0
votes
0 answers
Updates/Inserts on base tables slowing down due to associated indexed views
We have a stored procedure that UPDATES a table based on some conditions. And in the same stored procedure, INSERTS into the same table on some other conditions. Now this destination table has a bunch of associated indexed views which slows down the…
user_me
- 21
- 4
0
votes
0 answers
Indexed or Materialized view replicating on SQL Server DB from Oracle DB
Goal is for the most simple/nimble way to have a number of tables in a production Oracle DB, replicated on a SQL Server DB (for reporting purposes) and as close to real time.
Currently, I'm doing something like:
insert into SQL_Svr_tab select *…
lzc
- 919
- 7
- 16
0
votes
0 answers
Turn off system versioning of temporal table that is used in indexed views
I have a table that is used by a number of indexed views that I want to convert to a temporal table. All the commands to add the necessary columns and to set SYSTEM_VERSIONING=ON with a history table all succeeded. But now I can not disable system…
JeremyWeir
- 24,118
- 10
- 92
- 107
0
votes
1 answer
Simple SQL Update executes very slowly
SQL Server 2008 R2.
Running a simple Update command that looks like this
UPDATE [group_mtm] SET group = foobar where user in (u1,u2,u3,...u19)
The query only updates 1 row but takes in excess of 2 seconds. This is a 2 attribute table used as a…
zentechinc
- 369
- 1
- 5
- 15
0
votes
1 answer
sql server - create an indexed view using query results that concatenate row results into 1 column
I am trying to do this:
Concatenate many rows into a single text string?
And I want to have the query results join against other tables. So I want to have the csv queries be an indexed view.
I tried the CTE and XML queries to get the csv results…
user2760273
- 123
- 4
- 11