eBook - Group - RaqForum

eBook • 832 Reference • 98 Reply • 0 Follow

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

«1 ... 7 8 9 10 11 12 13 14 15 16 ... 34»

mars • eBook • 435 View • 2024-08-09 14:09:22
4.7 Temp dimension table and segmented dimension table
mars • eBook • 337 View • 2024-08-09 14:08:23
4.6 Alignment sequence
mars • eBook • 387 View • 2024-08-09 14:07:24
4.5 Filtering on dimension table
mars • eBook • 361 View • 2024-08-09 14:05:43
4.4 Numberized dimension table
mars • eBook • 357 View • 2024-08-09 14:03:44
4.3 Wide table
mars • eBook • 292 View • 2024-08-09 14:01:12
4.2 Computations on a dimension table
mars • eBook • 396 View • 2024-08-09 13:57:24
4.1 Storing dimension table in memory
mars • eBook • 374 View • 2024-08-09 13:55:40
3.8 Complicated judgment on each group
mars • eBook • 296 View • 2024-09-25 21:15:07
3.7 Getting the first/last record from each group
mars • eBook • 364 View • 2024-08-09 13:50:55
3.6 Order-based grouping & summarization
mars • eBook • 337 View • 2024-08-09 13:48:04
3.5 Order-based COUNT DISTINCT
mars • eBook • 277 View • 2024-08-09 13:46:32
3.4 Order-based DISTINCT
mars • eBook • 368 View • 2023-01-12 09:01:50
3.3 Storing data in account order
mars • eBook • 375 View • 2024-08-09 13:44:03
3.2 Order-based filtering
mars • eBook • 340 View • 2024-09-25 21:10:44
3.1 Storing data in time order
mars • eBook • 369 View • 2024-09-25 21:09:16
2.7 Getting the first/last record from each group
mars • eBook • 343 View • 2024-08-09 13:41:46
2.6 When there is a redundant grouping field
mars • eBook • 287 View • 2024-08-09 13:41:08
2.5 Getting records containing top/bottom N
mars • eBook • 353 View • 2024-08-09 13:39:57
2.4 Getting top/bottom N values
mars • eBook • 320 View • 2024-08-09 13:39:28
2.3 Getting record(s) containing the max/min value
mars • eBook • 327 View • 2024-08-09 13:38:13
2.2 DISTINCT
mars • eBook • 312 View • 2024-08-09 13:37:35
2.1 COUNT DISTINCT
mars • eBook • 329 View • 2024-08-09 13:36:21
1.4 Conversion from enumerated string to small integer
mars • eBook • 366 View • 2024-08-09 13:35:06
1.3 Converting date to small integer
mars • eBook • 427 View • 2024-09-25 21:04:08
1.2 Composite table

«1 ... 7 8 9 10 11 12 13 14 15 16 ... 34»

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