Results 1 to 3 of 3

Thread: How do you improve the Query performance in Teradata

  1. 07-19-2007 #1
    Geek_Guest
    Guest

    How do you improve the Query performance in Teradata

    How do you improve the Query performance in Teradata? I know that in ORACLE we use the HINTS. Can some one tell me the Tips/Tricks?

    Question asked by visitor Nithin

    Reply With Quote Reply With Quote
  2. 03-12-2008 #2
    ssheeba1
    ssheeba1 is offline
    Junior Member
    Join Date
    Mar 2008
    Answers
    1

    Re: How do you improve the Query performance in Teradata

    Quote Originally Posted by Geek_Guest View Post
    How do you improve the Query performance in Teradata? I know that in ORACLE we use the HINTS. Can some one tell me the Tips/Tricks?

    Question asked by visitor Nithin

    by collecting statistics on the column .u can improve the performance

    Reply With Quote Reply With Quote
  3. 05-13-2010 #3
    holyevil05
    holyevil05 is offline
    Junior Member
    Join Date
    May 2010
    Answers
    1

    Re: How do you improve the Query performance in Teradata

    definately, collecting stats is very effective.... You can also try using GTT tables. If a query is long and have lots of joins and derived tables.. GTT is the best option. Because you cannot use collect stats on derived columns.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact