Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: prepared-statement

What exactly does PostgreSQL (or other databases) do internally when you “prepare” a query rather than just running it directly?

By adminPosted on January 9, 2023

Question : When I face a huge number of repeated INSERTs in a loop, I tend to first create a […]

Postgres sometimes uses sequential scan instead of an index only scan for data that doesn’t exist

By adminPosted on December 8, 2022

Question : We are using Postgres 12 and We have a simple table like this: > d live_event_segmentation Table “public.live_event_segmentation” […]

MariaDb: right syntax of PREPARE statement for CONNECT type tables when passing string variable

By adminPosted on December 1, 2022

Question : I run 10.4.12-MariaDB on Windows10 and I use 64-bit ODBC driver to connect tables from MS Access to […]

Where is the generic plan stored when using PREPARE statement in PostgreSQL?

By adminPosted on November 29, 2022

Question : According to the document, if a prepared statement is executed enough times, the server may eventually decide to […]

PreparedStatement caching size on Oracle and SQL Server

By adminPosted on November 22, 2022

Question : I understand that PreparedStatements are complied and cached by database servers. I would like to know if all […]

How much should I care about prepared statements for simple queries?

By adminPosted on November 14, 2022

Question : I wonder how much I should care about prepared statements (and therefore try to optimize my code) in […]

Multiple statement conditions using OR AND within the query

By adminPosted on August 7, 2022

Question : I have this survey table and I’m trying to gather the information of userid who answer Strongly agree […]

column precision exceeded. ORA-01438 is so unmeaningful

By adminPosted on July 29, 2022

Question : I am not sure if this is a question to StackExchange DB Admin group. please let me know […]

MySQL stored routine performance while using PREPARE

By adminPosted on July 27, 2022

Question : Instead of maintaining stored routines for each database in my current environment I have decided to create separate […]

Catching slow queries with prepared statements

By adminPosted on May 28, 2022

Question : I use extended events to identify slow queries, defined as queries taking more than 2 seconds to complete, […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • Index issue on upgrade from SQL Server 2000 to 2012
  • How to set up SQL Server 2017 as a service
  • How can one identify if FK’s needed to be indexed apart from the NC indexes already residing
  • INSERT array elements from JSON object as table rows
  • Table design for efficiently retrieving “most recent row” per FK’d item whose PK is a GUID
  • Why does my BETWEEN predicate not match any rows? [closed]
  • MySQL using a index referencing a different column
  • mysql – Recovering databases from ibdata1 , .frm and .idb
  • Postgres: What could cause the error “cannot call populate_composite on a scalar”?
  • Safely changing innodb_buffer_pool_size on MySQL replication master?
  • Why my index don’t update?
  • MySQL – What exactly does smallint(2) permit? [duplicate]
  • Optimize a slow nested loops join
  • How to perform query operation on another query result
  • Identity column re-seed: when it is necessary?
  • MySQL -> Loop through a table, running a stored procedure on each entry
  • Optimize Postgresql query
  • How to speed up mysql query?
  • How to optimize a query for < operator
  • SQL Server transaction log [duplicate]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding