Well i have a database on my production server which is containing a table
having 10 million records and daily 10 - 20 K records are being inserted int
o
the same. The Table is also containing 25 indexes on different columns so
which is best time and way to reindex my table for newly inserted records.
Please helpAmit Patel wrote:
> Well i have a database on my production server which is containing a
> table having 10 million records and daily 10 - 20 K records are being
> inserted into the same. The Table is also containing 25 indexes on
> different columns so which is best time and way to reindex my table
> for newly inserted records.
> Please help
multi-post. see response in other ng.
David Gugick
Imceda Software
www.imceda.com
Monday, March 19, 2012
Indexing Huge Table
Labels:
containing,
database,
huge,
indexing,
inserted,
microsoft,
million,
mysql,
oracle,
production,
records,
server,
sql,
table,
tablehaving
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment