Snippet content copied to clipboard.
Are you sure to delete this snippet? No, don't delete
  1. -- Running these queries 1 after 1
  2. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'SPY' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  3. -- With Index: 3.8sec Without Index: 4.33sec
  4. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'INTC' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  5. -- With Index: 899ms Without Index: 375MS
  6. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'GS' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  7. -- With Index: 227MS Without Index: 353MS
  8. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'GOOG' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  9. -- With Index: 558MS Without Index: 389MS
  10. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'JPM' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  11. -- With Index: 233MS Without Index: 304MS
  12. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'C' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  13. -- With Index: 277MS Without Index: 730MS
  14. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'BAC' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  15. -- With Index: 114MS Without Index: 270MS
  16. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'MSFT' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  17. -- With Index: 575MS Without Index: 393MS
  18. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'IBM' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  19. -- With Index: 333MS Without Index: 342MS
  20. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'XOM' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  21. -- With Index: 276MS Without Index: 301MS
  22. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'CLF' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  23. -- With Index: 131MS Without Index: 274MS
  24. (SELECT price, side, shares, tape_time FROM 'orderbooks' where ticker = 'EEM' and shares > 0 and tape_time in '2022-09-14') LATEST on tape_time PARTITION BY price;
  25. -- With Index: 111MS Without Index: 310MS

Edit this Snippet