Hi.

Thx for all taht reply my question.

So, what does it mean when I issue the following statement in sqlplus;

create index rev_order_idx1 on rev_order(order_no, prod_id) ;

if I have 5 millions rows in rev_order table, will Oracle generate a lot of redo logs or will there only 1 entry (creating index statement into the relo log) ?

Thx