Hello,
How expensive would it be to maintain the following VIEW:

CREATE VIEW origin AS SELECT DISTINCT origin FROM transaktion

if there is in index on transaktion.origin; the table transaktion has thousands of records and there are only a few distinct origin?

--


Regards/Gruß,

Tarlika Elisabeth Schmitz

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to