calculation.
The main reason is that this method does not reduce the number of multiplication of matrices. Matrix multiplication consumes much more time than matrix addition. So the breakthrough of the optimization algorithm is to reduce the multiplication operation . ~~~
According to the thought of the divide-and-conquer method, it can be seen that if we want to reduce the number of multiplication, the key is to calculate the product of 2 2-order matrices and use less than 8 times.
Strassen pr
and in is that the in-boot clause can only return a single field, such as:Select name from student where sex = ' m ' and mark in (select-from-grade where ...), the IN clause returns three fields, which is incorrect, theexists clause is allowed, but in only one field is allowed to return, and two fields can be randomly removed in the three-way.Not exists and not are the opposite of exists and in.exists (SQL returns the result set as true) notexists (SQL does not return a result set to true)The
exists (SQL returns result set, true)Not EXISTS (SQL does not return result set, true)As follows:Table AID NAME1 A12 A23 A3Table BID AID NAME1 1 B12 2 B23 2 B3Table A and table B are 1-to-many relationships a.id = B.aidSelect Id,name from A where EXIST (SELECT * from B where a.id=b.aid)Execution results are1 A12 A2The reasons can be analyzed as followsSelect Id,name from A where EXISTS (SELECT * from B wher
EXISTS (SQL returns the result set as true)Not EXISTS (SQL does not return result set is true)As follows:Table AID NAME1 A12 A23 A3Table BID AID NAME1 1 B12 2 B23 2 B3Table A and table B are 1-to-many relationships a.id = B.aidSelect Id,name from A where EXIST (SELECT * from B where a.id=b.aid)Execution results are1 A12 A2The reasons can be analyzed as followsSelect Id,name from A where EXISTS (SELECT * fro
returns the result set as true)Not EXISTS (SQL does not return result set is true) The following is a detailed description of the process of NOT exists: As follows:Table AID NAME1 A12 A23 A3Table BID AID NAME1 1 B12 2 B23 2 B3Table A and table B are 1-to-many relationships a.id = B.aidSelect Id,name from A where EXISTS (SELECT * from B where a.id=b.aid)Execution results are1 A12 A2The reasons can be analyz
= ' Wang ' or name= ' Zhao 'The result is the same.The example is as follows (that is, exists returns the same value in the WHERE clause after 2 comparisons, and not exists returns the different values in the WHERE clause):EXISTS (SQL returns the result set as true)Not EXISTS (SQL does not return result set is true)As follows:Table AID NAME1 A12 A23 A3Table BID AID NAME1 1 B12 2 B23 2 B3Table A and table B are one-to-many relationships a.id-b.aidSelec
.
2. CDMA 1X Network Structure
is-95a Evolution to CDMA 1X Network, the circuit domain part of its core network is consistent with the IS-95, but in order to satisfy the packet data service, only the new PCF (Group control function), PDSN (Packet Data Service node), AAA (authentication, authorization and billing) and HA (attribution agent) and other grouped domain network elements are needed. To add A8, A9, A10, A11 interface processing between BSC-PCF and PCF-PDSN business and signaling messa
detailed description of the process of NOT exists:As follows:Table AID NAME1 A12 A23 A3Table BID AID NAME1 1 B12 2 B23 2 B3Table A and table B are 1-to-many relationships a.id = B.aidSelect Id,name from A where EXISTS (SELECT * from B where a.id=b.aid)Execution results are1 A12 A2The reasons can be analyzed as followsSelect Id,name from A where EXISTS (SELECT * from B where b.aid=1)--->select * from B WHER
that there is no upstream interface; this bit is not allowed by the new product)G, indicating the upstream GBIC interface;P indicates the upstream SFP interface;T, indicating the upstream RJ45 interface;V indicates the upstream VDSL interface;W indicates that the WAN interface can be configured on the uplink;C, indicating that the upstream interface is optional;M, indicating that the uplink interface is a Multimode Optical port;S indicates that the uplink interface is a single-mode optical port
heading "Instance" new_value inst_name format a12;Column db_name heading "DB Name" new_value db_name format a12;Column dbid heading "DB Id" new_value dbid format 9999999999 just c;
PromptPrompt Current InstancePrompt ~~~~~~~~~~~~~~~~
Select d. dbid, D. name db_name, I. instance_number inst_num, I. instance_name inst_nameFrom v $ database d,V $ instance I;
Variable dbid number;Variable inst_num number;Begin
Service department";Sheet. range["A9"]. Value = "Technical Department";Sheet. range["A10"]. Value = "Technology development";Sheet. range["A11"]. Value = "technical support";Sheet. range["A12"]. Value = "Pre-sales support";Sheet. range["A13"]. Value = "After-sales support";Copy CodeStep three: Set the Issummaryrowbelow property to False, that is, the summary row appears above the detail lineSheet. Pagesetup.issummaryrowbelow = false;Copy CodeStep fou
Exists (the result set returned by SQL is true)Not exists (SQL does not return true result sets)As follows:TableID name1 A12 A23 A3
Table BId aid name1 1 B12 2 B23 2 B3
A. ID => B. Aid
Select ID, name from a where exist (select * from B where a. ID = B. Aid)The execution result is1 A12 A2The cause can be analyzed as follows:Select ID, name from a where exists (select * from B where B. Aid = 1)---> Select *
" new_value inst_num format 99999;Column inst_name heading "instance" new_value inst_name format A12;Column db_name heading "DB name" new_value db_name format A12;Column dbid heading "db id" new_value dbid format 9999999999 just C;PromptPrompt current instancePrompt ~~~~~~~~~~~~~~~~Select D. dbid, D. Name db_name, I. instance_number inst_num, I. instance_name inst_nameFrom v $ database D,V $ instance I;Vari
1. One of the differences between exists and in is that exists executes external queries before executing subqueries. In is used to first execute subqueries and then execute primary queries;
The correlation is that the table of the exists primary query is larger than that of the subquery, and that of the in primary query is smaller than that of the subquery;
2. Example
Now we have tables A and B.
TableID name1 A12 A23 A3
Table BId aid name11 B122 B232
not exists is described in detail below:
As follows:TableID name1 A12 A23 A3
Table BId aid name1 1 B12 2 B23 2 B3
A. ID => B. Aid
Select ID, name from a where exists (select * from B where a. ID = B. Aid)The execution result is1 A12 A2The cause can be analyzed as follows:Select ID, name from a where exists (select * from B where B. Aid = 1)---> Select * from B where B. Aid = 1 A value returns true,
local aggregation values of Worker1, Worker2, Worker3, and Worker4 are recorded as follows:
A11, A12, A13, and A14; for clustering machine A2, the local clustering values of Worker1, Worker2, Worker3, and Worker4 are recorded as follows:
A21, A22, A23, and A24. After the computation is complete, each Worker sends the local clustering value to the Owner of the clustering machine. The Owner of the clustering machine merges and aggregates the data when
Summary:Exists (the result set returned by SQL is true) not exists (the result set returned by SQL is true) is as follows: Table A ID name 1 A1 2 A2
Exists (the result set returned by SQL is true)Not exists (SQL does not return true result sets)As follows:TableID name1 A12 A23 A3
Table BId aid name1 1 B12 2 B23 2 B3
A. ID => B. Aid
Select ID, name from a where exist (select * from B where a. ID = B. Aid)Run [Zhi hang] and the result is1
provided for educational purposes only and not supported by Oracle Support Services. it has been tested internally, however, and works as incluented. we do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.
Proofread this script before using it! Due to the differences in the way text editors, e-mail packages and operating systems handle text formatting (spaces, tabs and carriage returns ), this script may not be in an executable state when y
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.