query-performance
Cost of SORT is slowing down my query
PostgreSQL 7.4 (Yep upgrading) So in my WHERE condition I have this AND CASE WHEN \"substring\"(t.\"FieldID\"::text, 0, 3) = \'01\'::text[详细]
2023-04-04 20:48 分类:问答SQL Performance, What executes faster in the SELECT and WHERE conditions
UPDATE: Crap! it\'s not an integer it\'s character varying(10) Executing the query like this uses the index[详细]
2023-04-04 15:48 分类:问答HBase scan with compare filters has long delay when returning last row
I have HBase running in standalone mode and encountered some problems when I query the tables using the Java API.[详细]
2023-03-30 06:06 分类:问答Help improving a query. Trying to use EXPLAIN
I have a query that really isn\'t that complicated. Its taking close to 250ms to run, which is pretty slow. I\'ve analyzed the query using EXPLAIN and noticed a seq scan. I have the proper indexes in[详细]
2023-03-29 07:04 分类:问答Why is one query extremely slow, yet identical query on similar table runs in the blink of an eye
I have this query ...which runs extremely slowly (almost a minute): select distinct main.PrimeId from PRIME main[详细]
2023-03-27 09:21 分类:问答Optimizing Query. Want to pick the last record without using max in sub-query
This is my query: SELECT B.RECORDID, A.ITEMCODE, A.ITEMNAME, A.STOCKINHAND, B.SALEPRICE FROM ITEMMASTER A, STOCKENTRY B[详细]
2023-03-26 08:42 分类:问答Why does this oracle select statement take minutes to complete?
These tables have less than 20 fields, properties has about 9 million rows while listings has 3 million rows, but that should not be a problem.This is what databases are for...[详细]
2023-03-22 19:39 分类:问答sql performance problem
I have a database with 24M records in SQL Serv开发者_开发问答er 2000. When I run this query select * from cdr[详细]
2023-03-06 16:33 分类:问答Optimized way to get x Random rows satisfying given criteria in MySQL
I need to get x rows from a Database Table which satisfy some given criteria. I know that we can get random rows from MySQL using ORDER BY RAND ().[详细]
2023-02-11 12:04 分类:问答SQL EXISTS performance
I understand that SQL EXISTS checks for the existence o开发者_运维知识库f rows, however does it evaluate the entire expression? So for example, would something like this:[详细]
2023-02-05 18:25 分类:问答