python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - database-performance

SQL Server odd Performance results when querying/not querying checking for NULL values

I have to modify a query that is checking that a given date falls between the StartDate and EndDate fields of some View result set. Since there is no row with null values in those fields, the followin...
test-img

Ada

sql

sql-server

query-optimization

database-performance

Votes: 0

Answers: 1

Latest Answer

if StartDate can be null also then SELECT * FROM SomeView WHERE ((StartDate IS NULL) ) AND ((EndDate IS NULL) ) union all SELECT * FROM SomeView WHERE ((StartDate IS NOT NULL) and (StartDate <...
test-img

KumarHarsh

T-SQL -- faster way to do match for NOT LIKE &#39;%[^0-9]%&#39; used in CASE/WHEN statement

I am looking for a potentially faster way to do this check: NOT LIKE '%[^0-9]%' This checks to ensure all characters are numbers (see description of T-SQL pattern) Is there a faster way to do this in...
test-img

JosephDoggie

sql-server

tsql

query-optimization

sql-like

database-performance

Votes: 0

Answers: 1

Latest Answer

In this context performance of LIKE / NOT LIKE operator is almost for sure not a problem. If your query is slow consider first how many rows you are returning and if you are doing full scans on tables...
test-img

mkaczynski

Oracle Redo Logs All Active

First, I know very little next to nothing about being an OracleDba. I am responsible for managing an application using Oracle 11g written by a third party. Our application/database has been stable for...
test-img

David Gerst

oracle

switch-statement

database-performance

logfile

Votes: 0

Answers: 2

Latest Answer

If the destination to where your writing your logs are filling up that can freeze your system. I would check to see if there are abd unusual spikes on a hourly and daily basis. Hourly Archive Log Gen...
test-img

Beefstu

Postgres - same query two different EXPLAIN plans

I have two postgres databases (one for development, one for test). Both have the same structure. I'm running this query on both (merges one table into another) WITH moved_rows AS ( DELETE FROM m...
test-img

ConanTheGerbil

postgresql

database-performance

Votes: 0

Answers: 2

Latest Answer

This change was made with commit f0f13a3a08b27, which didn't make it into the release notes, since it was considered a bug fix: Fix estimates for ModifyTable paths without RETURNING. In the past, we ...
test-img

Laurenz Albe

Posts

Questions

Blogs

Jobs