>How long does it take to simply browse the table(s)? Another benefit of views is to exclude data that isn't relevant. If the user is only viewing certain fields, only include them. If there is a simple identifier to exclude rows from being viewed, you can use a parameterized view, which tends to be much faster than loading the entire table.
>
>SELECT Field1, Field2 FROM mytable WHERE Field1.Value = ?SpecifiedValue
>
>
>Chris.
Good point. Further to this, if using parameterised view, don't forget to set NoDataOnLoad for the view cursor in your DE. Thus the view will only gather the data when you set the param and say go.
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
