Interested to Buy Any Domain ? << Click Here >> for more details...
How to improve the query performance without taking the
collect statistics? In explain plan i have 'NO CONFIDENT'.
- 2 Answers
- 6681 Views
- I also Faced
- E-Mail Answers
Answer Posted / tdguy
Use execution plan and try to analyze the execution steps.
Try to tune the query. Use secondary index or join index
appropriately, if necessary.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the various indexes in teradata? Why are they preferred?
What are the various reporting tools in the market?
what is sysdba and sysdbc ? which has high priority ?
What are differences between teradata and ansi session modes in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What is the purpose of upsert command?
What are the uses of client software involved in teradata?
How can you track login parameters of users in teradata?
Explain fallback in teradata?
How to run a query in teradata?
What is the basic syntax for teradata select statement?
What is the syntax for case when statement?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What interface is used to connect to windows based applications?
