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
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