Interview Questions |
|
Teradata Indexes Teradata Indexes The Optimal Teradata Index is a NUPI with a USI Download Free Document Imaging Software ----------------------------------- Selection of Primary Index PI Column set should provide good data distribution, join efficiencies and fequently used access path Software Testing jobs? Jobs For Freshers ----------------------------------- Single-AMP A one-AMP or Single-AMP request uses the row hash to determine which AMP contains the requested rows.An example of a single-AMP request is primary index retrieval Multi-AMP A Multi-AMP request may use two or more AMPs. Examples of two-AMP requests are unique secondary index retrieval and a row inserted to a fallback protected table. All-AMP When the requested data resides on any AMP, then an all-AMP request is required to obtain it. Examples of all-AMP requests are full-table scans, some joins and all retrivals based on non-unique secondary indexes Sample Aptitude Questions for SAT, GMAT and GRE ----------------------------------- |
| Contact Us | Terms of Use | Privacy Policy | Site Map | © 2009 TechInterviewQuestions.com |