| Version 1 (modified by , 4 months ago) ( diff ) |
|---|
Query Optimization
Attachments (62)
- 1.png (19.8 KB ) - added by 4 months ago.
- 2.png (32.2 KB ) - added by 4 months ago.
- 3.png (12.6 KB ) - added by 4 months ago.
- 4.png (28.5 KB ) - added by 4 months ago.
- 5.png (139.7 KB ) - added by 4 months ago.
- 6.png (24.6 KB ) - added by 4 months ago.
- 7.png (13.5 KB ) - added by 4 months ago.
- 8.png (18.7 KB ) - added by 4 months ago.
- 9.png (13.3 KB ) - added by 4 months ago.
- 10.png (13.5 KB ) - added by 4 months ago.
- 11.png (28.6 KB ) - added by 4 months ago.
- 12.png (111.9 KB ) - added by 4 months ago.
- 13.png (25.2 KB ) - added by 4 months ago.
- 14.png (13.0 KB ) - added by 4 months ago.
- 15.png (18.5 KB ) - added by 4 months ago.
- 16.png (13.7 KB ) - added by 4 months ago.
- 17.png (26.3 KB ) - added by 4 months ago.
- 18.png (69.9 KB ) - added by 4 months ago.
- 19.png (40.4 KB ) - added by 4 months ago.
- 20.png (14.1 KB ) - added by 4 months ago.
- 21.png (7.5 KB ) - added by 4 months ago.
- 22.png (26.3 KB ) - added by 4 months ago.
- 23.png (70.1 KB ) - added by 4 months ago.
- 24.png (40.5 KB ) - added by 4 months ago.
- 25.png (14.2 KB ) - added by 4 months ago.
- 26.png (29.0 KB ) - added by 4 months ago.
-
view1k.jpg
(22.2 KB
) - added by 3 months ago.
View customer_payment_ride
-
optimization1k.jpg
(11.0 KB
) - added by 3 months ago.
Time for query on view customer_payments_ride
-
optimization2k.jpg
(7.8 KB
) - added by 3 months ago.
Time for insert in Payment
-
view2k.png
(18.4 KB
) - added by 3 months ago.
View reviews_on_drivers
-
optimization3k.png
(27.3 KB
) - added by 3 months ago.
Time for query on view reviews_on_drivers
-
optimization4k.jpg.png
(25.5 KB
) - added by 3 months ago.
Time for insert in Review
-
analyze1k.png
(116.1 KB
) - added by 3 months ago.
Query plan
-
analyze2k.png
(53.5 KB
) - added by 3 months ago.
Query execution
-
view3k.png
(56.8 KB
) - added by 3 months ago.
View reports_on_drivers_rides
-
optimization5k.png
(31.9 KB
) - added by 3 months ago.
Time for query on view reports_on_drivers_rides
-
optimization6k.png
(23.7 KB
) - added by 3 months ago.
Time for insert into Report
- analyze3k.png (125.4 KB ) - added by 3 months ago.
- analyze4k.png (61.6 KB ) - added by 3 months ago.
- advdb 1.png (11.3 KB ) - added by 3 months ago.
- advdb 2.png (77.9 KB ) - added by 3 months ago.
- advdb 3.png (29.2 KB ) - added by 3 months ago.
- advdb 4.png (7.9 KB ) - added by 3 months ago.
- advdb 10.png (11.8 KB ) - added by 3 months ago.
- advdb 5.png (11.1 KB ) - added by 3 months ago.
- advdb 6.png (83.3 KB ) - added by 3 months ago.
- advdb 7.png (29.2 KB ) - added by 3 months ago.
- advdb 11.png (41.9 KB ) - added by 3 months ago.
- advdb 12.png (12.7 KB ) - added by 3 months ago.
- advdb 13.png (10.7 KB ) - added by 3 months ago.
- advdb 14.png (5.7 KB ) - added by 3 months ago.
- advdb 15.png (11.8 KB ) - added by 3 months ago.
- advdb 16.png (37.4 KB ) - added by 3 months ago.
- advdb 17.png (12.9 KB ) - added by 3 months ago.
- advdb 18.png (10.8 KB ) - added by 3 months ago.
- advdb 19.png (11.9 KB ) - added by 3 months ago.
- advdb 20.png (76.7 KB ) - added by 3 months ago.
- advdb 21.png (33.3 KB ) - added by 3 months ago.
- advdb 22.png (6.8 KB ) - added by 3 months ago.
- advdb 23.png (14.3 KB ) - added by 3 months ago.
- advdb 24.png (79.8 KB ) - added by 3 months ago.
- advdb 25.png (33.6 KB ) - added by 3 months ago.
Note:
See TracWiki
for help on using the wiki.
