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&quo

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 m

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:

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:

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"

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