Oh, I forgot to mention..
mat_category is indexed and mat_id is PK.

One more question:
I am doing one of the updates..
update mwebMatrix
set Mat_Role_ID = 1
where Mat_role_id is null;
commit;

I want to see what is happening with this update..because its been 2 hours since I ran it.. and its still not finished.
I did select * from v$session and the session is active.
I cannot do.. to see if any records are getting updated because it hungs and never comes back.
select count(*) from mwebmatrix where mat_role_id = 1; show

When I did this it said..
SQLWKS> Select event from v$session_wait
2> where sid=11
3>
EVENT
-----------
db file sequential read
what does this mean ?

thanks

[Edited by sonaliak on 06-28-2001 at 10:27 AM]