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
- 6713 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 can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
Explain the term 'foreign key' related to relational database management system?
Name the five phases that come under MultiLoad Utility.
what happen if a query fail in dispatcher?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
In Teradata, what is the significance of UPSERT command?
What is the difference between correlated sub queries and inner queries?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
What is meant by a Virtual Disk?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is meant by a Clique?
Teradata 
