eBook - Group - RaqForum

eBook • 782 Reference • 74 Reply • 0 Follow

Default Hot Nice Preferred Recent reply
performance optimization practice(38)

«1 ... 5 6 7 8 9 10 11 12 13 14 ... 32»

mars • eBook • 331 View • 2024-08-09 06:09:22
4.7 Temp dimension table and segmented dimension table
mars • eBook • 277 View • 2024-08-09 06:08:23
4.6 Alignment sequence
mars • eBook • 314 View • 2024-08-09 06:07:24
4.5 Filtering on dimension table
mars • eBook • 289 View • 2024-08-09 06:05:43
4.4 Numberized dimension table
mars • eBook • 281 View • 2024-08-09 06:03:44
4.3 Wide table
mars • eBook • 230 View • 2024-08-09 06:01:12
4.2 Computations on a dimension table
mars • eBook • 312 View • 2024-08-09 05:57:24
4.1 Storing dimension table in memory
mars • eBook • 314 View • 2024-08-09 05:55:40
3.8 Complicated judgment on each group
mars • eBook • 238 View • 2024-09-25 13:15:07
3.7 Getting the first/last record from each group
mars • eBook • 309 View • 2024-08-09 05:50:55
3.6 Order-based grouping & summarization
mars • eBook • 218 View • 2024-08-09 05:48:04
3.5 Order-based COUNT DISTINCT
mars • eBook • 220 View • 2024-08-09 05:46:32
3.4 Order-based DISTINCT
mars • eBook • 291 View • 2023-01-12 01:01:50
3.3 Storing data in account order
mars • eBook • 302 View • 2024-08-09 05:44:03
3.2 Order-based filtering
mars • eBook • 251 View • 2024-09-25 13:10:44
3.1 Storing data in time order
mars • eBook • 314 View • 2024-09-25 13:09:16
2.7 Getting the first/last record from each group
mars • eBook • 291 View • 2024-08-09 05:41:46
2.6 When there is a redundant grouping field
mars • eBook • 234 View • 2024-08-09 05:41:08
2.5 Getting records containing top/bottom N
mars • eBook • 296 View • 2024-08-09 05:39:57
2.4 Getting top/bottom N values
mars • eBook • 258 View • 2024-08-09 05:39:28
2.3 Getting record(s) containing the max/min value
mars • eBook • 256 View • 2024-08-09 05:38:13
2.2 DISTINCT
mars • eBook • 253 View • 2024-08-09 05:37:35
2.1 COUNT DISTINCT
mars • eBook • 263 View • 2024-08-09 05:36:21
1.4 Conversion from enumerated string to small integer
mars • eBook • 294 View • 2024-08-09 05:35:06
1.3 Converting date to small integer
mars • eBook • 349 View • 2024-09-25 13:04:08
1.2 Composite table

«1 ... 5 6 7 8 9 10 11 12 13 14 ... 32»

4.7 Temp dimension table and segmented dimension table

4.6 Alignment sequence

4.5 Filtering on dimension table

4.4 Numberized dimension table

4.3 Wide table

4.2 Computations on a dimension table

4.1 Storing dimension table in memory

3.8 Complicated judgment on each group

3.7 Getting the first/last record from each group

3.6 Order-based grouping & summarization

3.5 Order-based COUNT DISTINCT

3.4 Order-based DISTINCT

3.3 Storing data in account order

3.2 Order-based filtering

3.1 Storing data in time order

2.7 Getting the first/last record from each group

2.6 When there is a redundant grouping field

2.5 Getting records containing top/bottom N

2.4 Getting top/bottom N values

2.3 Getting record(s) containing the max/min value

2.2 DISTINCT

2.1 COUNT DISTINCT

1.4 Conversion from enumerated string to small integer

1.3 Converting date to small integer

1.2 Composite table

Recent hot

New group

Contribute open source GitHub