Re: [PERFORM] View & Query Performance

2004-10-15 Thread Richard Huxton
Igor Maciel Macaubas wrote: Hi all, I'm trying to find smarter ways to dig data from my database, and have the following scenario: table1 -- id -- name . . . . . . table2 -- id -- number . . . . . . I want to create a view to give me back just what I want: The id, the name and the number. I tought

Re: [PERFORM] View & Query Performance

2004-10-15 Thread Alban Medici (NetCentrex)
Médici From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Maciel MacaubasSent: jeudi 14 octobre 2004 23:03To: [EMAIL PROTECTED]Subject: [PERFORM] View & Query Performance Hi all,   I'm trying to find smarter ways to dig data from my database, and have the following

[PERFORM] View & Query Performance

2004-10-14 Thread Igor Maciel Macaubas
Hi all,   I'm trying to find smarter ways to dig data from my database, and have the following scenario:   table1 -- id -- name . . . . . .   table2 -- id -- number . . . . . .   I want to create a view to give me back just what I want: The id, the name and the number. I tought in doing the fo