The creation of an index for the following table is on my sapdb installation very slow.
CREATE TABLE Buchungssaetze ( ID INT NOT NULL, TS INT NOT NULL, Transaktion INT NOT NULL, Sollbuchung BOOLEAN NOT NULL, Art INT NOT NULL, Konto INT NOT NULL, Kostenstelle INT NOT NULL, Kostentraeger INT NOT NULL, Betrag FIXED(18,2) NOT NULL, BetragWhg FIXED(18,2) NOT NULL, Steuercode INT NOT NULL, Steuerbetrag FIXED(18,2), Skontobetrag FIXED(18,2), SkontobetragWhg FIXED(18,2), Buchungstext VARCHAR(40), PRIMARY KEY (ID) )
CREATE INDEX Buchungssaetze1 ON Buchungssaetze (Konto) CREATE INDEX Buchungssaetze2 ON Buchungssaetze (Betrag)
The table Buchungssaetze has 9.135.068 rows.
Transbase (our current database system) requires to create the index Buchungssaetze1 51 seconds and to create Buchungssaetze2 86 seconds
The table with the same data on the same maschine requires with sapdb 7.4.3.30 for
Buchungssaetze1 over 15 minutes and for
Buchungssaetze2 half a day
If I make an index with an other column of the table of type INT it requires always around 15 minutes, for type FIXED always more than half a day.
How can I find out whats wrong (configured) with sapdb? Which parameters of the database influence the speed of index creation? How can I increase the speed?
Any suggestions or other experiences with "big" tables with sapdb/maxdb are welcome.
Best regards, Martin
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
