mibuso.com
Home› SQL Tips & Tricks
Options

Use indexed views to increase the speed of your queries

bbrownbbrown 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

  • Options
    David_SingletonDavid_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
  • Options
    garakgarak Member Posts: 3,263
    thats the 5th post where i know it's from a bot......
    Do you make it right, it works too!
  • Options
    David_SingletonDavid_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
Sign In or Register to comment.