[GENERAL] Optimizer picks an ineffient plan

2003-09-03 Thread Bupp Phillips
I have a customer table that has the field CUSTOMER_ID as the primary key (cust_pkkey), the table has 102,834 records in it. The following select statement works fine: select * from customer order by customer_id; QUERY PLAN: Index Scan using cust_pkkey on customer (cost=0.00..5175.17 rows=10283

Re: [GENERAL] Optimizer picks an ineffient plan

2003-09-04 Thread Bupp Phillips
Well, it's unfortunate that you feel that way, because SQL Server handles it correctly. "Tom Lane" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Greg Stark <[EMAIL PROTECTED]> writes: > > "Bupp Phillips" <[EMAIL PROTECTED]> writ