Generated by All in One SEO v4.9.7.2, this is an llms.txt file, used by LLMs to index the site.

# dbsherpa.com

Database Architecture, SQL, and Optimization

## Sitemaps

- [XML Sitemap](https://dbsherpa.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [PostgreSQL Query Spelunking with pg_stat_statements](https://dbsherpa.com/postgresql-query-spelunking-with-pg_stat_statements/) - Learn how to install and use the pg_stat_statements extension in Postgres to monitor query performance over time
- [CREATE VIEW AS SELECT * does not dynamically adjust to the underlying object](https://dbsherpa.com/create-view-as-select-does-not-dynamically-adjust-to-the-underlying-object/) - It never ceases to amaze me how I can be humbled every day. When you work with a technology for so long, teaching, writing, presenting, training, and mentoring…you start to think you’re an expert. You think by now you know all the basics, advanced aspects and nuances. And yet, despite your experience, there it is:
- [BULK COLLECT and COUNT() do not raise NO_DATA_FOUND](https://dbsherpa.com/bulk-collect-and-count-do-not-raise-no_data_found/) - I thought I knew bulk operations well. Today, while coding up a quick hunk of PL/SQL, the code did not behave as expected. Basically, I’d had a senior moment and forgotten something that I think my novice DBA and developer readers might benefit from. When you try to select some rows from a data structure
- [Dropping a View Drops the Instead-of Triggers](https://dbsherpa.com/dropping-a-view-drops-the-instead-of-triggers/) - On top of using this blog to speak on data and database design and development, I’ll also be using it as a notebook, documenting the moments of discovery and clarity that occur when dealing with problems. I wish I’d been taking notes this way since I began my career in 1995, instead of just hoping

## Pages

- [Papers and Presentations](https://dbsherpa.com/papers-and-presentations/) - A chronological history of research, tool evaluations, papers and presentations written for the Oracle, Postgres, and Data Architecture communities.Email me if a link is dead. Articles, Tool Reviews, and Comparisons Embarcadero’s RapidSQL (2001)Allround Automation’s PL/SQL Developer (2005)KeepTool’s Hora (from 2007) All the known Oracle Tools and IDEs (2007)PL/SQL IDE Comparison Matrix (2007) All the PL/SQL
- [History of the dbSherpa](https://dbsherpa.com/history-of-dbsherpa/) - I maintained a website at dbartisans.com for almost 20 years, primarily as a place to ftp things and keep all my stuff. But as a website written from scratch in 2001 XHTML, it was not suitable as a blog.So I migrated it all to a WordPress blog, and named it DB Sherpa, partially due to:
- [About dbSherpa](https://dbsherpa.com/about-dbsherpa/) - What is a sherpa? A wiry, tough, well-adapted Nepali who guides, watches over, and ensures the success of ambitious mountain climbers.This site and its resources are similar!Experiences, observations, tips, white papers, and presentations meant to help those attempting to scale the learning curve of database design and development.We hope to ensure your work is fun
- [PL/SQL "Starter" Framework](https://dbsherpa.com/pl-sql-starter-framework/) - The PL/SQL "Starter"1 application framework is a collection of packages, views, and tables designed to simplify and jump-start the development of custom Oracle-based applications. These are well-documented, tested, proven2 and easy to use. Instead of writing your own, adopt these components and save months of design and development. The framework is open source and lightweight.

## My Templates

- [Default Kit](https://dbsherpa.com/?elementor_library=default-kit)

## Categories

- [Database](https://dbsherpa.com/category/database/)
- [Oracle](https://dbsherpa.com/category/database/oracle/)
- [PostgreSQL](https://dbsherpa.com/category/database/postgres/)
- [SQL](https://dbsherpa.com/category/sql/)
- [Optimization](https://dbsherpa.com/category/database/database-optimization/)
- [Query Tuning](https://dbsherpa.com/category/sql/sql-query-tuning/)

## Tags

- [Oracle](https://dbsherpa.com/tag/oracle/)
- [Triggers](https://dbsherpa.com/tag/triggers/)
- [Drop View](https://dbsherpa.com/tag/drop-view/)
- [PL/SQL](https://dbsherpa.com/tag/pl-sql/)
- [Bulk Operations](https://dbsherpa.com/tag/bulk-operations/)
- [Bulk Collect](https://dbsherpa.com/tag/bulk-collect/)
- [Instead-of](https://dbsherpa.com/tag/instead-of/)
- [Views](https://dbsherpa.com/tag/views/)
- [SQL](https://dbsherpa.com/tag/sql/)
- [PostreSQL](https://dbsherpa.com/tag/postresql/)
- [Postgres](https://dbsherpa.com/tag/postgres/)
- [pg_stat_statements](https://dbsherpa.com/tag/pg_stat_statements/)
- [SQL Tuning](https://dbsherpa.com/tag/sql-tuning/)
- [SQL Monitoring](https://dbsherpa.com/tag/sql-monitoring/)