Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Unanswered: Index, What's (using btree)


    I'm trying to understand the Index and I got a doubt...

    well, I see that some index have the clause "using btree" and other no have this clause..

    create index "informix".ix_bi_nog_bi_pc_rep_fin on nog_bi_pc_rep_fin
    (ano,mes) using btree;

    create index "informix".ix2_bi_nog_bi_pc_rep_fin on nog_bi_pc_rep_fin
    (ano,mes) ;

    What the different between they ?

  2. #2
    Join Date
    Apr 2007
    Jundiai / SP - Brasil
    there is no differ.

    btree is the default option.

    Other options is rtree index, but are used only with Spatial/Geodict and other situations.
    César Inacio Martins
    Jundiai / SP - Brasil - em Português - English (translated by Google).

Posting Permissions

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