Re: Limitation on Views

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 02 Aug 1999 22:17:51 +0800
Message-ID: <37A5A88F.77EA@yahoo.com>

Nandakumar wrote:
>
> I have a table with 20 different types of records and i want to create a
> view for each type. Could anyone clarify if there is any limit on number
> of views on a table? Are there any performance issues when views are
> more?
>
> Finally, is there any limit on number of views in a data base?
>
> --
> Nandakumar
> Systems Analyst
> New York
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Number of views on table - no limit

Number of views in database - no limit (assuming sufficient space in SYSTEM tablespace)

No overhead performance problems since the views are just stored as their definition...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Aug 02 1999 - 09:17:51 CDT