Just to add, newer versions of Oracle have "analyze validate structure onlne" although in the case of indexes, it doesn't appear to populate index_stats :-( On 8/4/05, raja rao <raja4list@xxxxxxxxx> wrote: > HI All, > > Does the analyze table compute statistics (or dbms_stats) statement lock > the table > in anymode > > Thanks, > Raj -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- //www.freelists.org/webpage/oracle-l