Use indexed views to increase the speed of your queries

bbrown
bbrown Member Posts: 3,268
edited 2009-06-23 in SQL Tips & Tricks
This is a nice tip for a pure SQL enviroment, but I'm not sure how applicable it is for C/Side. Also there can be a trade-off to indexed views. While they can improve read performance on specific queries, this comes at the cost of needing to maintain them during the write process. Overusing/misusing indexed views can be just as bad as not using them.
There are no bugs - only undocumented features.

Comments

  • David_Singleton
    David_Singleton Member Posts: 5,479
    bbrown wrote:
    ... but I'm not sure how applicable it is for C/Side.

    who said it had anything to do with Navision :mrgreen:

    this user is basically a bot. There are a whole lot right now testing the security of mibuso. My web site (wiki.dynsamicbook.com) is also being hit at the moment by what looks like a similar spammer.

    FYI this text is just copy pasted from http://www.databasejournal.com/features/mssql/article.php/1437361/SQL-Server-2000-Optimization-Tips.htm
    David Singleton
  • garak
    garak Member Posts: 3,263
    thats the 5th post where i know it's from a bot......
    Do you make it right, it works too!
  • David_Singleton
    David_Singleton Member Posts: 5,479
    There are a lot more than five. What is odd is that some of them (like the michelle bot) are actually doing something, in this case creating a link to that hr page to help Google rankings. But a number of the others are just testing. Those are far more dangerous because once they are safe they will come back and do damage. Most likely edit the user profile or the thread itself with viagra advert. I had a few of these a few months back and just ignored them, and now they are everywhere on my wiki. Damn I hate these people.
    David Singleton

Categories