Archive for statistics
You are browsing the archives of statistics.
Number crunching through clustering
Separating your data into buckets is useful in a lot of problems especially fraud detection. How do you mathematically ‘cluster’ your data? One statistical way is the K-means clustering. Without delving into too much statistics, here is a spreadsheet you can use to do this for your own data. This sheet accepts pairs of two [...]
Performance tuning SQL queries in Oracle
Video tutorial showing how to optimise your SQL queries for maximum performance. Talks about indexes, statistics, hints and optimiser plans.
