Post reply

big query

  • May 30, 2014 at 4:33 am

    #293838

    Hi all,

    Today, we got one query for performance tuning, which is like, selecting 460 columns from 60 tables.

    My doubts

    1. I feel the no of columns are too high. are the no of columns or tables ok for any query in general ?

    ( i am not talking about maximum no of columns or tables given by MS sql server)

    2.I have never come across such a big query, can this type of query be tuned by placing the useful indexes

    3.Do I need to break this into multiple queries. ?

    Please advice, based on your info, if required, I will post the DDL

    Thank you

  • May 30, 2014 at 8:40 am

    #1717801

    You might need to post more information to get good advice. Check the following article to know how to do it.

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • May 30, 2014 at 9:37 am

    #1717847

    Thanks for the reply Luis, but I have come to know that the query is built using hibernate. so it automatically creates the query in the application.

    I am not sure this can be modified with our modified query

  • May 30, 2014 at 10:32 am

    #1717880

    So there's nothing we can do to help as you can't control the query?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply