Lars Have you run this query outside the AR system? E.g. Through SQLplus / SQL query analyser?
Regards Danny On 14 Aug 2013, at 07:31, lars.j.petters...@vattenfall.com wrote: > ** > Hi, I have problem using the import tool, it can take 10 seconds to import > one entry from a file…this has worked fine before with the same code. > > We have isolated to problem to the sql below, which is run several > times/record, and this sql takes a lot of time. > > T1 is Ar System Message Catalog > > There is one index for this form which has been rebuilt without any better > performance > > > SELECT T1.C1,C152,C155,C156 FROM T1 WHERE ((T1.C8 = '302') AND (T1.C7 > = 0) AND > (T1.C150 = 0) AND ((T1.C152 LIKE 'SVE%') OR (T1.C152 IS NULL))) ORDER > BY C152 ASC, 1 ASC > > > Any ideas? > > 7.6.04 > > // BR Lars > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
