Interested to Buy Any Domain ? << Click Here >> for more details...
Where we use PPI in real time??? What is the disadvantages
of PPI?
- 3 Answers
- 10842 Views
- IBM, Mphasis, I also Faced
- E-Mail Answers
Answer Posted / tdguy
adv: If the query uses a range within the partition, FTS
can be avoided. faster than secondary index, if used
properly. Deletion of partitions is fast.
disadv: when joined to non partitioned table, may take
long time to process.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is database exceptions in teradata?
What are the functions involved in shared information architecture?
In Teradata, what is the significance of UPSERT command?
Explain teradata utilities. What is multiload, fast load, tpump?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the enhanced features in teradata v2r5 and v2r6?
What is the use of fallback?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is meant by a Highest Cost Plan?
What are the different methods ot loading a dimension table? A fact table etc?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
