Pk_column is the primary key column. Sandeep On 10/18/05, amit poddar <amit.poddar@xxxxxxxx> wrote: > what is theis pk_column ? > just curious > > Sandeep Dubey wrote: > > > > > > > > >I created index on (col1, nvl(col2, pk_column)) > > > > > > > > -- //www.freelists.org/webpage/oracle-l