Top 50 performance Interview Questions
The most frequently asked performance questions across all roles and companies, ranked by real interview frequency. Updated daily.
Optimize a PostgreSQL reporting query by reducing scanned rows, preserving unmatched records, and selecting the latest related review efficiently.
Tata Consultancy Services (North America)PPriority Technology Holdings, LLC
ZillowOptimize a PostgreSQL aggregation query by filtering early, reducing rows before joins, and returning qualifying active customers.
SofteamSSoftware Medical Informatics
GlassdoorAggregate active endpoint traffic and error rates efficiently for high-traffic application monitoring.
Warner Bros. DiscoveryOOmnifoldAAstrelyaJoin BetMGM incident, workflow, and KPI data to rank the highest-impact operational bottlenecks by month.
Detect a heavily skewed join key and produce a deterministically salted join result for more balanced large-scale processing.
DatabricksSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Simulate trailing-edge debouncing for Informatica asset search events using timestamps and a quiet-period state machine.
InformaticaLLenskart
AccentureImplement an LRU cache with constant-time get and put operations using a hash map and doubly linked list.
Snowflake
Groupon
RokuRefactor pairwise correlation computation by precomputing centered returns and exploiting matrix symmetry.
Balyasny Asset ManagementBBack Market