Hi Mas Susanto, Terima kasih atas attention nya... :) Invoice No ini sudah di pakai sbg index untuk beberapa process.. dan sudah di production. Dan tipe dari Invoice No = VARCHAR2, dan perubahannya dari 16 ke 20 :)
Thanks Piping On Wed, May 14, 2008 at 10:55 AM, Yoel Susanto <[EMAIL PROTECTED]> wrote: > Perubahannya dari berapa ke berapa? > Datatypenya apa? > ini maksudnya sekarang sudah di pakai sebagai index belum? > > 2008/5/14 Moch Firman N <[EMAIL PROTECTED] <mochfirman%40gmail.com>>: > > > > Dear All, > > > > Now, I am having an assignment to change the length of invoice no field. > > and I have some indexing process to use invoice no as the key. > > > > *The question:* > > is there impact to perfomance ? > > > > *Notes:* > > the data more than 15jt records > > > > Thank you for the kind attention. > > > > Best regards, > > Piping > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > Cheers, > Yoel Susanto > > www.indo-oracletech.com > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]

