Would this example be usable : http://hemantoracledba.blogspot.com/2010/08/creating-sparse-index.html Hemant K Chitale -- //www.freelists.org/webpage/oracle-l