Interested to Buy Any Domain ? << Click Here >> for more details...
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
- 1 Answers
- 4457 Views
- I also Faced
- E-Mail Answers
Answer / tdguy
As a developer, some steps(below) can be suggested.
1. look at the explain plan. check for the join types.
product joins and nested joins consume more time.
2. check for the confidence levels.
3. collect stats
4. use si, ji appropriately.
5. repeat the steps after tuning.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is sysdba and sysdbc ? which has high priority ?
Explain the parallel data extension in teradata?
How do you load Multiple files to a table by using fastload scripts?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Explain teradata vs. Redshift?
While creating table my dba has fallback or no fallback in his ddl. What is that?
If the script is aborted. why it is aborted and how can you identify ?
how do you manage the production space. what are the proactive methods you can take ?
Define views in teradata with syntax.
Why are oltp database designs not generally a good idea for a data warehouse?
How can we load single row of data into teradata database. please give me the process.
Teradata 
