On Fri, 25 Jun 2004 12:01:29 +0200, "Dennis Bartlett" <[EMAIL PROTECTED]> wrote:
>Hi Cisar > >Type 30 is a dynamic file, so it should be looking after >itself pretty >well. I believe there are time one of these needs resizing, >but as I >have none here, I cannot tell you how/where/when > >200,000 records is not really very much. I have some with >2,000,000. > >What WOULD help you enormously is if you build an index on >that file for >the ETIQUETTA column... eg > >> CREATE.INDEX GCMLIPE ETIQUETTA >> BUILD.INDEX GCMLIPE ETIQUETTA DET.SUP > >Your next select should fly... When you're doing that, look at the "NO.NULLS" option in the CREATE.INDEX command. Use of it can cut your index size down, which will also increase the speed of your select. If on the other hand you need to select with ETIQUETTA EQ "", then you'll want the nulls indexed. -- Allen Egerton [EMAIL PROTECTED] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
