-
analyze table
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
and
> 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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|