Dear all,
I run a query and I try to save results as a table. On the results of
this first query I want to run yet another query (perhaps a few).
I have been trying to use CREATE VIEW statement, which works fine,
except for the fact that fields are not indexed because as I
understand it
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a few).
I have been trying to use CREATE VIEW statement, which works fine,
except for the fact that
On 27.10.2009, at 15:11, Steve Edberg wrote:
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a few).
I have been trying to use CREATE VIEW statement,
At 3:29 PM + 10/27/09, Olga Lyashevska wrote:
On 27.10.2009, at 15:11, Steve Edberg wrote:
At 2:59 PM + 10/27/09, Olga Lyashevska wrote:
Dear all,
I run a query and I try to save results as a table. On the results
of this first query I want to run yet another query (perhaps a
few).
Dear Steve,
On 27.10.2009, at 16:19, Steve Edberg wrote:
Or you could do an ALTER TABLE afterwards to add appropriate
indexes. And are you familiar with the EXPLAIN command to help
optimize queries/decide what indexes to add?
Thanks for this! I have added indicies with ALTER TABLE.
And