-
-
Oracle query performance
A) I have 100 columns in emp table , which of the below queries will give good performance and WHY?1) Select * from emp;2)select col1,col2,col3,..............col100 from emp;B) we have 2 tables T1(100 records) and T2(1000) recordsWhen we use the below queries , it will generate Cartesian product , which query will give better performance and WHY?1)Selct * from t1,t2 ;2)select * from t2,t1;