Archives of the TeradataForum
Message Posted: Wed, 17 Mar 2004 @ 15:39:09 GMT
I am running a simple query
SELECT SQLCOR01.opportunity_id FROM crm_eport.opportunities SQLCOR01 WHERE SQLCOR01.status IN ('Order Received', 'Not Started' ,'Hold' ,'Lost' , 'Won' ) AND SQLCOR01.branch_id = 7628
When I look at the explain plan, I see it is estimated with low confidence even though I have statistics collected on all columns of this table.
Is there a more efficient way to write this query?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|