Also a SQL statement execution among different users, the data volume exactly the same as
An execution is less than 1 s will query out another has been executed, what reason;

 
Select * From tb_fgf_view f 
Inner join tb_czf_view c on c.s. _idcard=f.s _idcard 

=c.s. and f.s hi hiAnd f.q u=c.q u 
And f.l u=c.l u 
And f.h y=c. y 
And f.h l! C. l=
And f.d y=c.d y 
And f. eng=Arthur c. eng 
And f.h ao=c. ao 
Where xs_id='D5 and SFTF=0 

CodePudding user response:

The building Lord once tables of statistics is collected by dbms_stats package and grammar baidu first,

CodePudding user response:

Never make oracle, I now is to use, dbms_stats package collecting table statistics used when not knowing what to do

CodePudding user response:

F5 the same statement a finally have a full table scan
What the hell is this

CodePudding user response:

Confirm the two users view object is the same, check their users under the view definition