This tag pertains to performance issues with Structured Query Language (SQL): performance bottlenecks faced when managing data in relational database management systems.
When should I use KEY, PRIMARY KEY, UNIQUE KEY and INDEX?
mysql indexing primary-key unique-key sqlperformancePerformance question ... I have a database of houses that have geolocation data (longitude & latitude). What I want to do …
sql mysql database performance sqlperformanceSo, recently a DBA is trying to tell us that we cannot use the syntax of SELECT X, Y, Z …
sql-server stored-procedures temp-tables sqlperformanceI'm new to Oracle db. I have 2 queries which return the same result set. I want to measure the performance …
sql oracle sqlperformanceI have a table with 10 millions rows that I need to join with another table and update all data. This …
sql sql-server sql-update sqlperformanceI have a table which looks as follows..it has multiple columns for different latencies Date API Latency1_Avg Latency1_…
sql sql-server sql-server-2012 sql-function sqlperformanceI have one small doubt in query performance. Basically, I have a table with more than 1C records. sl_id …
sql postgresql sqlperformanceRecently I found a couple of tables in a Database with no Clustered Indexes defined. But there are non-clustered indexes …
sql-server sql-server-2008 indexing sql-server-2008-r2 sqlperformanceCould you guys please review the following query to an Oracle DB and point out what's wrong: SELECT t1.name …
sql oracle sqlperformance sql-tuningSELECT Trade.TradeId, Trade.Type, Trade.Symbol, Trade.TradeDate, SUM(TradeLine.Notional) / 1000 AS Expr1 FROM Trade INNER JOIN TradeLine ON …
sql sqlperformance