Skip to Content
author's profile photo
Former Member

Custom index on MSEG table

hi, i created a custom index on MSEG table. upon activation, a dialog appears w/ the ff info:

Create Index MSEG(dialog title)

Index must be created on the database.

Processing type

(radio buttons)

Online

Background

Enter for mass processing (TBATG)

i'd like to know why i was prompted for this whereas from other tables (custom & standard) i wasn't prompted? also, what is the impact if i choose online or background?

regards,

rico

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Jul 19, 2004 at 11:10 AM

    This is because there is data on the table already so the index needs to be built taking into account these existing entries.

    Based upon the size of this table, I would choose "background processing" although this is a task BASIS should handle.

    Cheers

    Colin.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2004 at 12:40 PM

    Hello Rico

    You could compare an index record to a database record.

    I don't think you want to create 5000000 records online, but with only 500 records you don't care, so if you examin the number of records in MSEG I guess you will know the ansver to online or background.

    Best regards

    Thomas Madsen Nielsen

    Add comment
    10|10000 characters needed characters exceeded