Christian Smith schrieb: > What is better is a view that dynamically returns rows based on the > underlying pairs table, rather than inserting into cols:
yup, I like views a lot but in my current case I have a speed problem. My "pairs" has more then 700.000 records. I need 10 fields so I have 10 joins in my query. The result of the query/view are 6000 Records. A select on the view is fast enough but I need a "select * from myview group by id" and this takes more the 10 seconds on a Xeon CPU 3.20GHz. Is there something I can do to speed up this beside create a new table? Many thanks Matthias
