|
|
|
Junior Member
 
Group: Forum Members
Last Login: 10/3/2006 2:30:00 AM
Posts: 20,
Visits: 1
|
|
select this.Job_Id as Job_Id0_, this.Label as Label0_, this.Description as Descript3_0_,
this.User_Name as User_Name0_, this.Active_Ind as Active_Ind0_,
this.Job_Event_Key as Job_Even6_0_, this.Group_Label as Group_La7_0_,
this.Completion_Event_Ind as Completi8_0_,
this.Schedule_Id as Schedule9_0_, this.Job_Status_Id as Job_Sta10_0_ from Tablename this where 1=1
Suppose i have the query given as above and is getting locked every time
i had generated the explain plan
1) First, we lock a distinct databasename."pseudo table" for read
on a RowHash to prevent global deadlock for databasename.this.
2) Next, we lock databasename.this for read.
3) We do an all-AMPs RETRIEVE step from databasename.this by way of
an all-rows scan with a condition of ("1 = 1") into Spool 1
(group_amps), which is built locally on the AMPs. The size of
Spool 1 is estimated with high confidence to be 112 rows. The
estimated time for this step is 0.06 seconds.
4) Finally, we send out an END TRANSACTION step to all AMPs involved
in processing the request.
-> The contents of Spool 1 are sent back to the user as the result of
statement 1. The total estimated time is 0.06 seconds.
SUSHANT P PARICHARAK Teradata Certified Professional
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/24/2008 8:31:03 AM
Posts: 109,
Visits: 22
|
|
Not sure as to what is the question that you want to ask. Can you elaborate?
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/3/2006 2:30:00 AM
Posts: 20,
Visits: 1
|
|
See every time this query is only getting locked since during the single user operation also here if i want to get rid from this locking issue what step should i perform
SUSHANT P PARICHARAK Teradata Certified Professional
|
|
|
|