On Tue, Feb 10, 2009 at 1:47 PM, Steven Buehler wrote:
> From: Jochem van Dieten:
>> What the database will do for you behind the scenes is expand your
>> usage of the view. In effect, the database will replace "x" with its
>> definition. So your query SELECT a FROM x; gets expanded to:
>> SELECT a
> -Original Message-
> From: Jochem van Dieten [mailto:joch...@gmail.com]
> Sent: Tuesday, February 10, 2009 5:10 AM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote:
> > Ok, I just saw a post abou
On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote:
> Ok, I just saw a post about using view's in mysql. I tried to look it up
> and found how to use it, but my question is: what is a view and why would
> you use it?
The problem with any definition of an object in a database is that
there are m
Steve
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Monday, February 09, 2009 3:59 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: Re: MySQL View
Steven,
I would suggest you the reading of a basic book about SQL and Databases, I
explain you why.
Views are a very fundam
t; Sent: Monday, February 09, 2009 11:26 AM
> To: Steven Buehler; ba...@xaprb.com
> Cc: mysql@lists.mysql.com
> Subject: RE: MySQL View
>
>
>
> My current understanding of the delta between Views and Temporary Tables
> Views are read only results from 1 or more tables ..in Oracle they
that sound
correct?
Thanks
Steve
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, February 09, 2009 11:26 AM
To: Steven Buehler; ba...@xaprb.com
Cc: mysql@lists.mysql.com
Subject: RE: MySQL View
My current understanding of the delta between Views and Temporary Tables
View
CC: mysql@lists.mysql.com
> Subject: RE: MySQL View
> Date: Mon, 9 Feb 2009 10:10:45 -0600
>
>
>
> > -Original Message-
> > From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> > Behalf Of Baron Schwartz
> > Sent: Monday, February 09, 2
> -Original Message-
> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> Behalf Of Baron Schwartz
> Sent: Monday, February 09, 2009 9:19 AM
> To: Steven Buehler
> Cc: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009
On Mon, Feb 9, 2009 at 9:41 AM, Steven Buehler wrote:
> Ok, I just saw a post about using view's in mysql. I tried to look it up
> and found how to use it, but my question is: what is a view and why would
> you use it? Is it like a temporary table? Does it write a new database to
> the disk or
Hi!
Daniel Kasak wrote:
[EMAIL PROTECTED] wrote:
Views differ from tables in that they cannot be indexed.
I've just started experimenting with derived tables under 4.1.14, and I
had a hunch this was so. Is there any plan to include index support for
views / derived tables?
An index is a s
[EMAIL PROTECTED] wrote:
Views differ from tables in that they cannot be indexed.
I've just started experimenting with derived tables under 4.1.14, and I
had a hunch this was so. Is there any plan to include index support for
views / derived tables?
--
Daniel Kasak
IT Developer
NUS Consulti
Thanks a lot Shawn.
I didn't realize that views don't take advantage of indexing. This is the
cause of my major performance hits. I'm basically using views as a form of
DB abstraction over the tables. So, many of my views pull all records from
all tables they join, and it is up to the user to s
Scott Klarenbach <[EMAIL PROTECTED]> wrote on 01/06/2006 08:13:10
PM:
> Hello,
>
> I'm new to views and am discovering massive performance hits in the
views
> I've created once the records start to climb above 20,000 or so. Does
> anyone know of a great primer/tutorial site for optimizing view
13 matches
Mail list logo
