Under the very wrong assumption that it wouldn't take long, I've ran ALTER INDEX ALL ON OUR_BIGGEST_TABLE REORGANIZE;. 3 and a half hours later, it's not finished. From cruel experience, I know that I can repopulate that table from scratch (i.e. from truncation) in 7 hours. Presumably, truncation and re-population also refreshes the indexes. Does this mean that my REORGANIZE is extremely unlikely to take more than 7 hours?
Is the time needed to reorganize the indexes on a table bounded above by the time that it takes to repopulate from scratch?
216 Views Asked by J. Mini At
0
There are 0 best solutions below
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in T-SQL
- Dynamic query creation with Array like implementation
- How to locate relevant tables or columns in a SQL Server database
- Calling a REST API from SQL Server
- How do I use Poor Man's T-SQL Formatter in SSMS v20?
- sp_executesql Not Working with a Parameters search nvarchar
- Using MSXML2.ServerXMLHTTP with SQL Server status, statusText and responseHeader are all null
- tsql functions like REPLACE() failing in azure data factory pipeline connected to salesforce
- GROUP BY with multiple nested queries T-SQL
- How to get the superset of all XML paths from an XML column in a table
- Split Invoice Total into multiple Rows but Split always equals Total
- Conversion failed when converting date and/or time from character string while ordering by date or string
- SQL How to add a conditional to the aggregate function within a pivot table?
- Update the column which has sequence number dynamically
- SQL query to extract incremental data from a table in SQL Server
- Convert Date format in a table
Related Questions in INDEXING
- How to give index id to my uploaded json file in FastAPI?
- operator class "gin_trgm_ops" does not exist for access method "gin"
- what is it? my question is what's the meaning of img[img]
- If composite indexing created - indexing is called?
- Autocomplete not working for apache spark in java vscode
- Pyside6, tableView.selectedIndexes, list index out of range
- Indexing in ServiceNow Jelly Report not working
- Wordpress | Page indexing Page is not indexed: Redirect error
- Why does my attempt to print the index of my array ALWAYS return 0.00?
- jQuery - Click and enable Button without affecting other foreach Laravel arrays
- std:array indexing and operator[]
- ChartJS indexing for datapoints
- How to make Postgres GIN index work with jsonb_* functions?
- Using Closing Stock Balance as Opening Stock in subsequent line item
- Using MYSQL optimise table with innodb_optimize_fulltext_only and innodb_ft_num_word_optimize options, how do I know when it's finished?
Related Questions in BENCHMARKING
- How can I check OPA memory usage with big file size?
- Combine known-size slices into an array in rust
- appending one byte array dramatically fewer allocations than 2 byte array
- Measuring TensorFlow Lite Model Speed
- Understanding Parameters for Intel MKL LINPACK w/MPI `ppn` and `np`
- How to optimize the following conditional assignment of a vector?
- Improving Django Application Performance: Comparing Blocking and Non-blocking Implementations
- Achieving More FMA3 Performance Than The Theoretical Maximum
- How to turn off the level 3 cache on my AMD Threadripper Pro so I can get good benchmarking of my Gnu C++ code?
- double value contains 'm' at the end while printing in google benchmarks table
- How do I improve benchmark accuracy in Javascript?
- OCI runtime error while executing ML perf object detection benchmark
- Java: (Micro) benchmark library imports using JMH?
- Wrong memory benchmarking results in Golang
- I'm beginner.I wonder how to evaluate my own pretrain model on GLUE benchmark?
Related Questions in REORGANIZE
- Is there a way to reorganize and combine 4 tables to match a format of a table I need in R studio?
- db2 luw reorg table
- how to online reorg oracle tables with active replication trigger?
- Re-organising the data with desired sequence
- Changing a matrix from one to another with two row names in R
- How can I organize my code so that it's neater?
- MySQL reorganize lose the partitions info
- Is the time needed to reorganize the indexes on a table bounded above by the time that it takes to repopulate from scratch?
- visual studio code: How to rearrange and sort class members in java code
- How to convert a variable number of columns per row to multiple rows in R?
- How to create a column to reorganize data frame in R?
- Batch create folder based on partial file name and move files to folder
- Vacuum Full calibration for production context.(reorganize subjects identification)
- Reorganize multiple variables based on date variable in R
- Break the sublists with Python
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?