I am wondering if the result of executing REORGANIZE TABLE … KEY|INDEX and ALTER INDEX … REBUILD is the same or whether there are differences between these two statements?
asked 23 Jun '14, 05:28
robert 853●47●54●68 accept rate: 0%
FWIW: The question has come up as part of that FAQ:
Reorganize composite indexes
Once you sign in you will be able to subscribe for any updates here
Answers
Answers and Comments
Markdown Basics
learn more about Markdown
Question tags:
index ×29
question asked: 23 Jun '14, 05:28
question was seen: 4,269 times
last updated: 23 Jun '14, 06:08
SA-9 Using Hash Table; Degrading Performance
Index Consultant Clarification
Why include a primary key in a composite index?
How can i get the size of an index in SQL Anywhere 10 or 16?
What does a value of 5 in "SYSIDX.unique" mean?
indexing foreign key columns
How to force an index
How does SQL Anywhere build indexes for character data in v10 and above?
11.0.1.2405 Indexes not being used - Is this a known Problem?
How does a FOREIGN KEY with MATCH UNIQUE SIMPLE treat null values?
First time here? Check out the FAQ!
FWIW: The question has come up as part of that FAQ:
Reorganize composite indexes