IBM QUESTION
As all we know PE takes the SQL Request and it will give
responce for that query. what is the internal process
happening.how it is taking that sql from the system?????
thanks in Advance
Answer Posted / tdguy
When a SQL is submitted, processing starts with PE.PE
checks for syntax, checks for security and handles
sessions. Then it builds a plan. This plan is communicated
to the BYNET. Based on the plan, BYNET signals the
appropriate AMPS. AMPS inturn, retrieve or store the data
in the respective vdisks. Communications between the
components involve acknowledgement and response signals.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How many tables can you join in v2r5?
What are the functions of a Parser?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the most common data types used in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain the advantages of partitioned primary index in a query?
What is the purpose of using case expression in teradata?
How will you solve the problem that occurs during update?
Explain and compare pros and cons of start schemas?
What do you mean by teradata intellicloud?
What are the commands to make a new table, change a table and remove a table in teradata?
Explain the term 'foreign key' related to relational database management system?
What is the function of parser component in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
what is object level locking ? where do appear this type of locking ?