Questions tagged [table-statistics]
50 questions
0
votes
1 answer
min over one dimension followed by max over another dimension
I have an SQL table that looks like this:
i j x
0 0 0.5
0 1 1.0
0 2 1.5
1 0 1.4
1 1 1.3
1 2 1.2
and so on. I would like to take the average over the j dimension…
Phillip M. Feldman
- 468
- 1
- 7
- 17
0
votes
2 answers
dropping filtered statistics causes deadlocks
We have a large data warehouse database where we continuously get new rows inserted in 5 different tables, at the left(Edit: right)-hand side of the b-tree (=at end of the table)
This means that ordinary statistics very quickly gets outdated,…
Henrik Staun Poulsen
- 13,154
- 4
- 23
- 26
0
votes
1 answer
Making sales statistics for my ERP system, but performance is bad
I have a ERP system programmed in PHP with a mySQL database, with all my orders for the past 4 years in it. Now I would like to make a function to generate sales statistics. It should be possible to set search criteria like Salesman, Department and…
d4ta
- 75
- 1
- 6
0
votes
1 answer
record order in T-sql changing with statistics update
I am facing an issue with the record order in the given query.
SELECT
EA.eaid, --int , PK of table1
EA.an, --varchar(max)
EA.dn, --varchar(max)
ET.etid, --int
ET.st --int
FROM dbo.table1 EA
JOIN dbo.table2 ET ON EA.etid = ET.etid
JOIN…
-2
votes
1 answer
Testing for Normality in data set with many sites
I'm a comparative newbie to R and am trying to use it to assess the normality (or otherwise) of water quality data from around 1900 individual sites. Each site has a unique Sitecode with the results Meas_res of samples over a 3 years period. Data…
