History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: FRG-312
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: John V. Sichi
Reporter: John V. Sichi
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Farrago

create index on existing data should not hold catalog lock during execution

Created: 04/Mar/08 04:43 PM   Updated: 06/Mar/08 11:12 PM
Component/s: DDL
Affects Version/s: None
Fix Version/s: None


 Description  « Hide
Should take lock at beginning to update catalog, store index definition, and mark it as build-pending, then drop lock; then after execution, update state to reflect completion. Optimizer has to avoid trying to use index while build-pending, and if a crash occurs, need to figure out how to deal with the bad index.


 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
John V. Sichi - 06/Mar/08 11:12 PM
DROP INDEX has a similar issue, although it should run much faster.