Very slightly off topic but I am very sceptical about indexes. We had a database designed by a DBA with lots of indexes for this that and the other. This was an Oracle database and I read somewhere that only under certain conditions would the index be used. Did an explain plan on all the business related queries and none were utilising an index. So the end result was that all insertions, and subsequent deletions, where running slower than necessary because of of the creation and deletion of indexes. Got rid of the indexes and things ran significantly faster. Oh, and of course, the database storage requirements were also significantly reduced.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Clustered vs Non clustered indexes
Collapse
X
-
-
Good point there OrangeHopper. It's an example of what I was saying: you really have to suck it and see, and rationalise after the fact. What you'd think would improve things often turns out to have quite the opposite effect.Insanity: repeating the same actions, but expecting different results.
threadeds website, and here's my blog.Comment
-
Originally posted by OrangeHopper View PostSo the end result was that all insertions, and subsequent deletions, where running slower than necessary because of of the creation and deletion of indexes. Got rid of the indexes and things ran significantly faster.Comment
-
I think what OH is saying, is some inexperience DBA types/developers think, "If an index on a column speeds things up, I'll stick an index on every column of every table and the DB will run like lightning".
The database then has to maintain these indexes on every insert, update and delete.
The only true way to tune a database is against a representative set of captured SQL (a workload).Comment
-
Originally posted by OrangeHopper View PostSo the end result was that all insertions, and subsequent deletions, where running slower than necessary because of of the creation and deletion of indexes. Got rid of the indexes and things ran significantly faster.Coffee's for closersComment
-
Originally posted by DimPrawn View PostI think what OH is saying, is some inexperience DBA types/developers think, "If an index on a column speeds things up, I'll stick an index on every column of every table and the DB will run like lightning".If you have to add a , it isn't funny. HTH. LOL.Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment