>>I've used some parameterized views. They're handy when you need something to be updatable. What were you having trouble with?
>
>>-Michelle
>
>Do you have to have a Primary or Candidate index to use a parameterized view?
>
>Brenda

No. I don't have any in any of my tables, and I have a bunch of p-views. If your keys aren't unique, you could have trouble, but I don't think how you enforce the uniqueness matters.

-Michelle