-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/09/07 02:16, Ashish Karalkar wrote: [snip] > Disadvantages: > > > > 1) Performance : If a view is defined by complex multitable > query,then simple query against that view becomes a coplecated > join, and it may take a long time to complete I don't see that as relevant, since we know which objects are tables and which are views. But maybe that's just our site. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGQYL9S9HxQb37XmcRAqhIAKDTiOQpvifDk5nVU87MvGOjLqdV8wCffjf5 3lzftdxJzUDVhNaD9GME3VQ= =51Vx -----END PGP SIGNATURE-----