search

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3
https://code.mteixeira.dev/SublimeText-SQLTools/
GNU General Public License v3.0
177 stars 40 forks source link

Related to: #115 #118

Closed calope closed 7 years ago

calope commented 7 years ago

https://github.com/mtxr/SQLTools/issues/115

tkopets commented 7 years ago

This is a nice addition and as far as I understand the command "Describe Table" works as well with views in Oracle case. Can you confirm this (as I don't have Oracle connection to test)?

Performance imrpovement: Since table names and view names cannot overlap, there is no need to do a UNION (which leaves only unique values), instead we would get a better performance of those queries if we use UNION ALL instead of UNION.

calope commented 7 years ago

Confirm that it works correctly with the command describe table on Oracle Connection. I think it's a very good idea about UNION ALL.

tkopets commented 7 years ago

@calope Can you please push one more commit to this branch (pull request) with UNION ALL improvement?

calope commented 7 years ago

@tkopets Ok.

18bca385572a5c6d9dd0cfefa8cc6aff1600625b