Well Said Sara.
----- Original Message ----- From: "Sara Burns" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 31, 2004 1:57 PM Subject: RE: Modern Universe (TESTING) > As requested > > My queries were done on our machine reasonably early in the morning before > there were a lot of users. I repeated them to ensure that data was in > cache. > Both had the same format > SELECT CustomerNo > FROM CustomerFile > WHERE PostalAddLine1 like '%EXPLORATION%' > ORDER BY CustomerName > > I will admit that I was surprised at the performance when we set up the > index in UniVerse on that field. It showed me the value of using indexes. > Before indexes were available in UniVerse this was done by different means. > This type of select would not have been considered. I think this is a big > difference between Oracle and UniVerse. As these features have become > available in UniVerse etc some leap at the chance to use them and others > keep doing things the old way. Sometimes they may have been bitten by odd > bugs in the past. UniVerse has most of the latest features if we choose to > use them. This CustomerFile has 14 indexes. > > I cannot repeat the tests now as the machine is heavily loaded and will be > until late this evening. However I did try again just to convince myself > and got the same relativity. Maybe we need to tune Oracle better for this > query > > One possible difference is that this query is directly to the database from > our UniVerse application, not via an intermediate layer. > > AIX 5.2, UniVerse 10.0.11, Oracle 9.0.2 > > I think we should leave this discussion now. Maybe it is time for > experimentation - I have found you can get great improvements with the right > approach. > > Sara Burns (SEB) > Development Team Leader > > Public Trust > Phone: +64 (04) 474-3841 (DDI) > > Mobile: 027 457 5974 > < <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]> > > Information contained in this communication is confidential. If you are not > the intended recipient the information should not be used, disclosed, copied > or commercialised. The information is not necessarily the views nor the > official communication of Public Trust. No guarantee or representation is > made that the communication is free of errors, virus or interference. > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users