Schleifen Optimierung?

[Blup]

z.B. so:

SQL-Code:

SELECT c.*, 
  (SELECT count(p.Customer_Number)
   FROM   Position p
   Where  p.Customer_Number = c.Customer_Number) Anzahl
FROM Customer c

[edit=mkinzler]Code-Tag durch SQL-Tag ersetzt Mfg, mkinzler[/edit]