ca.portal.admin

IDMS-L Digest - 1 Mar 2005 to 2 Mar 2005 (#2005-45)

Discussion created by ca.portal.admin on Mar 2, 2005
Latest reply on Mar 2, 2005 by ca.portal.admin
There are 5 messages totalling 247 lines in this issue.

Topics of the day:

1. BUILD/REBUILD Indexes (4)
2. 2005 IDMS EDUCATION SCHEDULE

----------------------------------------------------------------------

Date: Tue, 1 Mar 2005 11:29:04 +0000
From: john.dell@AON.CO.UK
Subject: BUILD/REBUILD Indexes

Ina

Since you say you wish to 'tidy up' indexes, I conclude that the indexes
already exist, and therefore you need to REBUILD them. BUILD is usually
employed on SQL databases, but can also be employed on a non-SQL database
to create a new, unlinked, SYSTEM-owned mandatory automatic index.


Disclosure of Material Facts
Every Proposer or Insured / Reinsured when seeking new insurance / reinsurance or renewing an existing Policy must disclose any information which might influence the Insurer / Reinsurer in deciding whether or not to accept the risk, what the terms should be, or what premiums to charge. Failure to do so may render the insurance / reinsurance voidable from inception and enable the Insurer / Reinsurer to repudiate liability.

This email, together with any attachments, is for the exclusive and confidential use of the addressee(s) and may contain legally privileged information. Any other distribution, use or reproduction without the sender's prior consent is unauthorised and strictly prohibited. If you have received this message in error, please notify the sender by email immediately and delete the message from your computer without making any copies. While attachments are virus checked, Aon Limited does not accept any liability in respect of any virus which is not detected.

Aon Limited
Company Number: 210725
Registered Address: 8 Devonshire Square, London, EC2M 4PL

Aon Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only

------------------------------

Date: Tue, 1 Mar 2005 11:15:58 -0500
From: Alan Fields <Alan_Fields@VFC.COM>
Subject: Re: BUILD/REBUILD Indexes

BUILD is for SQL defined databases only.

MAINTAIN INDEX is for non-SQL databases. Within that, REBUILD will remake
existing structures.

The utilities manual has all the details.

Alan Fields
VF Services, Inc.
Greensboro, NC
336-424-4773
Alan_Fields@vfc.com




|---------+------------------------------->
| | ""Mason, Ina (DTUP)"" |
| | <Ina.Mason@TRANSPORT|
| | .SA.GOV.AU> |
| | Sent by: IDMS Public|
| | Discussion Forum |
| | <IDMS-L@LISTSERV.IUA|
| | SSN.COM> |
| | |
| | |
| | 03/01/05 02:51 AM |
| | Please respond to |
| | IDMS Public |
| | Discussion Forum |
|---------+------------------------------->
>--------------------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: IDMS-L@LISTSERV.IUASSN.COM |
| cc: |
| Subject: [IDMS-L] BUILD/REBUILD Indexes |
>--------------------------------------------------------------------------------------------------------------------------------------------------|




Would someone be able to tell me which one I should use if I want to tidy
up
indexes, do I use BUILD or REBUILD in MAINTAIN INDEX?
I think I read somewhere that BUILD can only be used for SQL database, is
this correct?

Thankyou
Ina Mason
Transport SA

------------------------------

Date: Tue, 1 Mar 2005 11:45:12 -0500
From: ""Wheeler, John"" <John.wheeler@MUTUALOFAMERICA.COM>
Subject: Re: BUILD/REBUILD Indexes

Ina,

While the BUILD utility is just for SQL, my answer to the question that you
asked ""Within the options available for the MAINTAIN INDEX, should one use
the BUILD or the REBUILD option"" is (as is normally the case in IDMS), it
depends on what one wants to do. If one is simply changing the page size or
number of pages in an index area containing MA system-owned indexes, I
prefer BUILD to REBUILD because there is nothing to REBUILD, the structure
was blown away.

When I am just cleaning up indexes, if nothing is changing, I use the
REBUILD option and the critical choice, when it comes to performance, is the
option used within the REBUILD statements.

However, 99% of the time, when it is time to clean up indexes, it is also an
opportunity to examine the decisions that were made either at creation or
the last time that they were cleaned-up and see if any modifications, based
on what has happened during the time period since the structures of the
indexes was last visited, would improve the operation of the index and make
any appropriate modifications.

John Wheeler

Outcomes