Professional Web Applications Themes

Create index VS Set Index Enabled - IDS 7.31 - Informix

Hi List, I am in the process of re-doing my production DB. One of the step I decide to perform was to "Set index enabled" instead of of re-creating them from scratch. So my question is: Is set index enabled exactly the same as the create index. Any comments are welcome !!! Thks ! Stephane sending to informix-list...

  1. #1

    Default Create index VS Set Index Enabled - IDS 7.31


    Hi List,

    I am in the process of re-doing my production DB.

    One of the step I decide to perform was to "Set index enabled" instead of of
    re-creating them from scratch.

    So my question is: Is set index enabled exactly the same as the create
    index.

    Any comments are welcome !!!

    Thks !

    Stephane

    sending to informix-list
    Stéphane Gadoury Guest

  2. #2

    Default Re: Create index VS Set Index Enabled - IDS 7.31


    Stéphane Gadoury wrote:
    > Hi List,
    >
    > I am in the process of re-doing my production DB.
    >
    > One of the step I decide to perform was to "Set index enabled" instead of of
    > re-creating them from scratch.
    >
    > So my question is: Is set index enabled exactly the same as the create
    > index.
    Not entirely. You have to create your indexes first, using the CREATE
    INDEX command. You can create indexes that are disabled, and then enable
    them later using the SET INDEXES command. Enabling an index will
    effectively rebuild the entire index.
    > Any comments are welcome !!!
    I wouldn't tempt OTC like that. ;-)

    Cheers,
    --
    Mark.

    +----------------------------------------------------------+-----------+
    | Mark D. Stock mailto:mdstockMydasSolutions.com |//////// /|
    | Mydas Solutions Ltd [url]http://MydasSolutions.com[/url] |///// / //|
    | +-----------------------------------+//// / ///|
    | |We value your comments, which have |/// / ////|
    | |been recorded and automatically |// / /////|
    | |emailed back to us for our records.|/ ////////|
    +----------------------+-----------------------------------+-----------+

    sending to informix-list
    Mark D. Stock Guest

  3. #3

    Default Re: Create index VS Set Index Enabled - IDS 7.31


    Which option is better and faster in term of
    performance, if I want to rebuild the huge table?

    --- "Mark D. Stock" <mdstockMydasSolutions.com>
    wrote:
    > Stéphane Gadoury wrote:
    > > Hi List,
    > >
    > > I am in the process of re-doing my production DB.
    > >
    > > One of the step I decide to perform was to "Set
    > index enabled" instead of of
    > > re-creating them from scratch.
    > >
    > > So my question is: Is set index enabled exactly
    > the same as the create
    > > index.
    >
    > Not entirely. You have to create your indexes first,
    > using the CREATE
    > INDEX command. You can create indexes that are
    > disabled, and then enable
    > them later using the SET INDEXES command. Enabling
    > an index will
    > effectively rebuild the entire index.
    >
    > > Any comments are welcome !!!
    >
    > I wouldn't tempt OTC like that. ;-)
    >
    > Cheers,
    > --
    > Mark.
    >
    >
    +----------------------------------------------------------+-----------+
    > | Mark D. Stock
    > mailto:mdstockMydasSolutions.com |//////// /|
    > | Mydas Solutions Ltd
    > [url]http://MydasSolutions.com[/url] |///// / //|
    > |
    > +-----------------------------------+//// / ///|
    > | |We value your comments,
    > which have |/// / ////|
    > | |been recorded and
    > automatically |// / /////|
    > | |emailed back to us for our
    > records.|/ ////////|
    >
    +----------------------+-----------------------------------+-----------+
    >
    > sending to informix-list

    __________________________________
    Do you Yahoo!?
    SBC Yahoo! DSL - Now only $29.95 per month!
    [url]http://sbc.[/url]
    sending to informix-list
    miyaki Guest

Similar Threads

  1. Replies: 4
    Last Post: August 3rd, 03:11 PM
  2. Trying to create an Index
    By Gabriel_Ayala@adobeforums.com in forum Adobe Indesign Windows
    Replies: 0
    Last Post: April 22nd, 07:59 PM
  3. Newb query: index.htm & index.php & the server default
    By Lab309 in forum PHP Development
    Replies: 7
    Last Post: September 22nd, 02:08 PM
  4. Logging with CREATE INDEX
    By Andy Kent in forum Informix
    Replies: 1
    Last Post: July 29th, 08:53 PM
  5. create index
    By xixi in forum IBM DB2
    Replies: 18
    Last Post: July 10th, 07:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139