|
|
|
|
|
by dagss
748 days ago
|
|
What I had in mind was the simple OLTP usecases. To compete with NoSQL in developer ergonomics. My context is people choosing NoSQL because SQL is too hard to learn and has too many caveats; not because of performance etc So basically a mode for the planner where you: - throw away statistics - consider all tables infinitely large - ...except the log(N) of an index lookup is OK - then find a non-infinite plan or crash Yes, it does not work in all cases. But it avoids giving SQL a bad reputation and push people towards NoSQL DBs for the common case of simplistic OLTP queries. The error should be seen during testing. The "DBA" sees it there are issues then you are deploying code without test coverage.. For more sophisticated queries, you would not enable this flag, and be aware that you are doing a nontrivial query. |
|