nicht angemeldet
Hi,
Vieleich habt ihr eine Lösung.
auf die Gefahr hin, dass das als nicht hilfreich angesehen wird: Aber wie groß in drei Teufels Namen bzw. wie komplex ist deine Suche? Solche Queries kenn ich ja von unserer 15Mio Datensatz-DB2-Tabelle noch nicht mal. Hast du mal mit explain gearbeitet um zu schauen, ob da Indizes etc. genutzt werden könnten/sollten?
MfG
Rouven
--
-------------------
Computer programming is tremendous fun. Like music, it is a skill that derives from an unknown blend of innate talent and constant practice. Like drawing, it can be shaped to a variety of ends: commercial, artistic, and pure entertainment. Programmers have a well-deserved reputation for working long hours but are rarely credited with being driven by creative fevers. Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination, but because their imagination reveals worlds that others cannot see. -- Larry OBrien and Bruce Eckel in Thinking in C#
-------------------
Computer programming is tremendous fun. Like music, it is a skill that derives from an unknown blend of innate talent and constant practice. Like drawing, it can be shaped to a variety of ends: commercial, artistic, and pure entertainment. Programmers have a well-deserved reputation for working long hours but are rarely credited with being driven by creative fevers. Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination, but because their imagination reveals worlds that others cannot see. -- Larry OBrien and Bruce Eckel in Thinking in C#