Hi,
If I delete many rows in a table which has got indexes, should I have to ask my DBA to run a kind of utility that re-organize the table and indexes.
Thanks in Advance .
Senthil
if a large portion is deleted/changed then yes, its adviseable to optimize the table.
it'll update statistics and defrag the pages.
this isn't needed very often, but something nice to do during normal maintence periods.
