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
- 6682 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Probably, we can try splitting the query by using volatile tables and tuning the query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
How to run the Teradata jobs in unix environment ???
How to select first n records in teradata?
How would you load a very large file in teradata in general?
What is the process to restart the multiload if it fails?
which option is used to restart the fastexport script ?
What are the uses of client software involved in teradata?
What is upsert statement in teradata?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
what is sysdba and sysdbc ? which has high priority ?
what are the uses of fact table and dimension table in banking project?
What is called partitioned primary index (ppi)?
Teradata 
