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
- 6822 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
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What are the various reporting tools in the market?
What is TPD?
What do you mean by caching in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
how do you manage the production space. what are the proactive methods you can take ?
What interface is used to connect to windows based applications?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How many sessions of MAX is PE capable of handling at a particular time?
Explain the term 'foreign key' related to relational database management system?
what is sysdba and sysdbc ? which has high priority ?
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?
