/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 akorotkov.github.io
ALTER INDEX ... SET STATISTICS ...? - Alexander Korotkov's blog
| | www.depesz.com
Waiting for 9.1 - Faster LIKE/ILIKE - select * from depesz;
2.6 parsecs away

Travel
| | [AI summary] This post details a PostgreSQL patch introducing faster LIKE and ILIKE index searches using pg_trgm, demonstrating significant performance improvements over sequential scans while discussing the trade-off with increased indexing and maintenance times.
| | www.crunchydata.com
Hacking the Postgres Statistics Tables for... | Crunchy Data Blog
1.1 parsecs away

Travel
| | Adding extended statistics can add information about how columns are related. Louise has some real life example queries and tips for working with extended table stats that can dramatically improve query performance.
| | newvick.com
Why understanding B-trees will help you improve database performance Newvick's blog
2.5 parsecs away

Travel
| | b-trees database indexes partial index function-based index multi-column index
| | tsqltuesday.com
T-SQL Tuesday #86 - SQL Server Bugs and Enhancement - T-SQL Tuesday
22.2 parsecs away

Travel
| [AI summary] The blog post discusses SQL Server bugs and enhancements, encouraging readers to report issues through Microsoft's Connect platform and participate in the improvement process.