Re: Questions?

On 15 Nov 97 at 20:33, Gerardo Garc'a wrote: } We are testing Informix & Metacube on NT and Unix } } We have knowlegde of Microsoft SQL Server and we have some questions } } 1: } How I can update/delete one table from a resulta of a subquery or a } view Example Update Table Set field1 = Table1.field1 >From Table, } Table1 Where Table.filed1 = Table1.field1 Yes. This is a straight RTFM type question, I'm afraid... :-) } 2: } Its posible to have the next results } } Select sum(Units) as Unit from SevenmillonRecordTable } } MS SQL Server INFORMIX 7.22 INFORMIX 7.23 } Alpha 4100 Alpha 4100 Intel } 4/200 } 768 MB RAM 1GB RAM 768 MB RAM } } 10 secs 3.5 min 4 min Yes, but: did you run an UPDATE STATISTICS? Have you done any aggregation? We do similar queries, actually *worse* queries with ranking and all sorts, and we get sub-second response - but not off just raw sequential scans without decent statistics. HTH. -- Ciao, Billy Swanning around in: Johannesburg, Sarf Efrica. Get the Informix FAQs of life at http://www.iiug.org/techinfo/faq/faq_top.html Need to get some drivel into your life? http://www.west.co.za/tasteless/