I'm now dealing with PLSQL developer, which is my very first time. And I find this kind of query
select * from tableA, tableB where tableA.field1 = tableB.field1(+)
I'm wondering the function of the
(+) in the query. Could you guys be so kind to explain it ?
The following recommendations will help you in your SQL tuning process.
You'll find 3 sections below:
ALTER TABLE `tableA` ADD INDEX `tablea_idx_field1` (`field1`); ALTER TABLE `tableB` ADD INDEX `tableb_idx_field1` (`field1`);
SELECT * FROM tableA, tableB WHERE tableA.field1 = tableB.field1(+)