Outer Web | Explore

Explore >> Select a destination

You are here		tanelpoder.com How to resolve SQL object and column names all the way to base tables and columns in Oracle? \| Tanel Poder Consulting
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 1, IN, EXISTS and COUNT >0)	1.2 parsecs away Travel
\|	\|	A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	1.2 parsecs away Travel
\|	\|	iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics	2.2 parsecs away Travel
\|	\|	??????? ?????? ?? ??????? ??????????? 465 ??????! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%????????%' OR A.LASTNAME LIKE '%????????%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ??? ???????, ????????? ???? ?? ??????? A.COMPANY_ID = 1 ???????? ??????? ???????????????? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT...	2.2 parsecs away Travel
\|	\|	mauro-pagano.com "When the going gets tough, the tough get going" aka SQLT XPLORE \| Mauro Pagano's Blog	2.9 parsecs away Travel
\|	\|	When upgrading a database sometime you find that one or more SQLs run slower because ofa new and suboptimal execution plan. Usually the number of those SQLs is pretty small compared to the overall workload but it's not straightforward to understand what caused the plan change so even a small number can become tricky to...	2.9 parsecs away Travel
\|	\|	connor-mcdonald.com Kris Kringle the Database - Getting the BAND together - Learning is not a spectator sport	19.2 parsecs away Travel
\|		Ever heard of a BAND join? It's not actually new, it has been around since 12.2. Jonathan Lewis wrote up a nice post on it was back in 2017 but in a nutshell MERGE join done without a band join SQL> select 2 e1.last_name\|\| ' has salary roughly between '\|\| e2.last_name comparison 3 from 4...	19.2 parsecs away Travel