Subject | Re: [firebird-support] Re: commit after insert is very slow |
---|---|
Author | Kjell Rilbe |
Post date | 2010-03-03T14:20:16Z |
svanderclock skriver:
cases? You may need one ascending and one descending index per column.
For ten columns that would result in twenty indexes. So, what are the
other ten for?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> yes absolutely of absolutely (of the absolutely) sure that i need allYou are aware that FB can combine single-column indexes in most (all?)
> thoses index ! and 30 index for one table is not look too much exagerated :(
cases? You may need one ascending and one descending index per column.
For ten columns that would result in twenty indexes. So, what are the
other ten for?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64