Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Indexed View or Not NOS / Weighted Avg?

Status
Not open for further replies.
lameid

lameid

Programmer
Jan 31, 2001
4,212
US
I am stuck on this as a matter of best practice and maybe feasability (My SQL Server knowledge is still mostly conceptual).

In the database there are often used queries that take a while to execute which makes me think that an indexed view is appropriate. However one of the tables involded sees a lot of bulk transactions. Is this problematic for perfomance with writing to both the table and the indexed view?

In looking at other posts, it seem like indexed views may bomb on aggregate functions (i.e. sum). Is that true?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
347
Mike Lewis
Mike Lewis
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
218
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Converting or getting rid of decimal places 1
Replies
5
Views
228
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
216
Chris Miller
Chris Miller
kingz2000
  • Locked
  • Question
View of Select from (select ...)
Replies
7
Views
159
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top