AW: AW: Query optimization problem

Euke Castellano wrote: > Gesendet: Donnerstag, 3. Februar 2005 16:00 > An: maxdb@lists.mysql.com > Cc: Becker, Holger > Betreff: Re: AW: Query optimization problem > > > Becker, Holger wrote: > > >Euke Castellano wrote: > > > > > >>>I

Re: AW: Query optimization problem

Becker, Holger wrote: Euke Castellano wrote: I have the following table definition: CREATE TABLE "CONSUM"( "ID" Integer NOT NULL, "HOTEL" Integer NOT NULL, "SERVICE" Integer NOT NULL, "SEGMENT" Integer NOT NULL, "GUEST" Integer, "COMPANY" Fixed (38,0), "AGENCY" Fixed (38,0), "REP

AW: Query optimization problem

Euke Castellano wrote: > > Marcus Obwandner wrote: > > > > > > > Euke Castellano schrieb: > > > >> Marcus Obwandner wrote: > >> > >> ... > > > > > >>> > >> Thanks Marcus: > >> This is my first experience with MaxDB and I think i don't catch some > >> concept, because what happends, I think isn't

Re: Query optimization problem

On Thursday 03 February 2005 15:38, Euke Castellano wrote: > Marcus Obwandner wrote: > It seems MaxDB is not able to create index on temporary table. (in > CREATE INDEX help content --> The specified table must be an existing > base table, and not a temporary table). So why not simply create a bas

Re: Query optimization problem

Marcus Obwandner wrote: Euke Castellano schrieb: Marcus Obwandner wrote: ... Thanks Marcus: This is my first experience with MaxDB and I think i don't catch some concept, because what happends, I think isn't normal. Perhaps something is wrong configured, i don't know For me that is not a

Re: Query optimization problem

Euke Castellano schrieb: Marcus Obwandner wrote: ... Thanks Marcus: This is my first experience with MaxDB and I think i don't catch some concept, because what happends, I think isn't normal. Perhaps something is wrong configured, i don't know For me that is not a MAxDB Problem more an SQ

Re: Query optimization problem

Marcus Obwandner wrote: Euke Castellano schrieb: Hi all, I have the following table definition: CREATE TABLE "CONSUM"( ... I also have an UNIQUE INDEX created on column INVOICEDATE. The table has ~25.000.000 rows. Normal Index OK, I read the second Message... When I try a query like:SELECT *

Re: Query optimization problem

Marcus Obwandner wrote: Euke Castellano schrieb: Hi all, I have the following table definition: CREATE TABLE "CONSUM"( ... I also have an UNIQUE INDEX created on column INVOICEDATE. The table has ~25.000.000 rows. Normal Index OK, I read the second Message... When I try a query like:SELECT * F

Re: Query optimization problem

Euke Castellano schrieb: Hi all, I have the following table definition: CREATE TABLE "CONSUM"( ... I also have an UNIQUE INDEX created on column INVOICEDATE. The table has ~25.000.000 rows. Normal Index OK, I read the second Message... When I try a query like:SELECT * FROM consum WHERE invoice

AW: Query optimization problem

Euke Castellano wrote: > > I have the following table definition: > > > > CREATE TABLE "CONSUM"( > >"ID" Integer NOT NULL, > >"HOTEL" Integer NOT NULL, > >"SERVICE" Integer NOT NULL, > >"SEGMENT" Integer NOT NULL, > >"GUEST" Integer, > >"COMPANY" Fixed (38,0), > >"AGENCY

Re: Query optimization problem

Euke Castellano wrote: Hi all, I have the following table definition: CREATE TABLE "CONSUM"( "ID" Integer NOT NULL, "HOTEL" Integer NOT NULL, "SERVICE" Integer NOT NULL, "SEGMENT" Integer NOT NULL, "GUEST" Integer, "COMPANY" Fixed (38,0), "AGENCY" Fixed (38,0), "REPRESENTATI

Query optimization problem

Hi all, I have the following table definition: CREATE TABLE "CONSUM"( "ID" Integer NOT NULL, "HOTEL" Integer NOT NULL, "SERVICE" Integer NOT NULL, "SEGMENT" Integer NOT NULL, "GUEST" Integer, "COMPANY" Fixed (38,0), "AGENCY" Fixed (38,0), "REPRESENTATIVE" Fixed (38,0), "I