We have an application written in ASP. It appends and deletes VFP tables via ODBC and in batches. Since ODBC creates large indeces (.cdx) for these tables and does not remove deleted records, after...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_20748431.html
Zones:
FoxProDate Answered: 09/26/2003 Grade: B Views: 0
Has anyone experienced a major slowdown on Windows 2000 or XP during a reindex? (VFP8) We are reindexing two file one 900mg another 600mg and the machines grinding to a halt. We are not issuing a ...
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_20824164.html
Zones:
FoxProDate Answered: 12/12/2003 Grade: A Views: 0
Can anyone tell me after a bulk upload into the database. Should I reindex the tables involved or update the statistics. Can anyone tell me the difference between the two and what are the benefits ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21623732.html
Hi I have been asked to run a DBCC REINDEXING JOB for our test database. What I need to do is then compare the performance with the production environment. What is the best way to do this.
1) ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21695156.html
Hi all, i need a dummy guide on how to repair or reindex a .CDX file in visual fox pro V5
I am a complete newbie to this, so please be gentle
Cheers in advance
http://www.experts-exchange.com/Microsoft/Applications/FoxPro/Q_21992992.html
Zones:
FoxProDate Answered: 09/18/2006 Grade: A Views: 0
How do I schedule a job to run to run a script at a certain time of the day to reindex a table.
I have the script to reindex it but I want it to run every 24 hours.
http://www.experts-exchange.com/Database/Miscellaneous/Q_22069436.html
Zones:
DatabasesDate Answered: 11/22/2006 Grade: B Views: 0
I need a working script that I can use to reindex all tables in my DB
I will schedule this as a job and run it biweekly. any inputs?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22646947.html
Hi there,
Has anyone got a stored procedure/SQL script which will rebuild the indexes on all of the tables in a database?
Cheers
Pete
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10311933.html
I have run a DBCC reindex on my Database weekly for several months. It normally takes about 40 minutes (4 Million rows), yesterday I ran it and after 15 hours I canceled it! There was no error mess...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10914861.html
I have added alot of new records and need to reindex 10 of the indexes in one table in SQL7. Is this what would be best?
DBCC DBREINDEX
('database.owner.table_name')
All assistance is g...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20438165.html
