Skip to main content
N West's user avatar
N West's user avatar
N West's user avatar
N West
  • Member for 13 years, 9 months
  • Last seen more than 1 year ago
  • Pittsburgh, PA, United States
comment
Constructing an SQL query with time intervals
All two minute intervals or all two minute "whole" intervals - e.g. are you bucketing the data by interval, or do you want to see all possible intervals (e.g. any span of time that is 2 minutes (to the second?) or just a bucketed set of minutes?
comment
In Oracle, why would an OR / LIKE(A,B) take far longer than running the same query for each condition separately and unioning
Perhaps there's an index on my_column that the optimizer decided not to use in the former case but did use in the latter? When was the last time you gathered stats on the tables? Any number of possibilities... but we need the real query plans...
revised
Loading…
awarded
awarded
awarded
Loading…
awarded
revised
Loading…
comment
Methodology & Architecture to Create ETL Process
He also wrote The Data Warehouse ETL Toolkit which is a through explanation of ETL architecture.
awarded
awarded
awarded
awarded
revised
Any Open Source / free ETL out there?
added 281 characters in body
Loading…
awarded
answered
Loading…