i have a table with 8 million rows.
the table has no indexes on it.
the table also has no stats on it.
if the only sql i do is
> select * from table
where columna is null
for update of columna
> update table
set columna = somevalue
what affect would analyzing the table do?
would you expect it to make a performance difference, and if so why?