joins in Database

Author Topic: joins in Database  (Read 20585 times)

Offline Brackwom

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 30
  • Karma: 0
Re: joins in Database
« Reply #10 on: 09-10-2021, 07:23:05 »
SQL specifies five types of JOIN : INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER and CROSS. if we can join two tables that will reduce the number of rows needed to be processed by subsequent steps, then our performance will improve.


 

Related Topics

  Subject / Started by Replies Last post
1 Replies
5252 Views
Last post 06-23-2015, 00:53:38
by Talukdar
0 Replies
2673 Views
Last post 12-22-2015, 00:15:35
by chinmay.sahoo
0 Replies
1731 Views
Last post 11-21-2016, 03:38:33
by aarav
4 Replies
8702 Views
Last post 03-29-2021, 04:21:32
by Lishmalinyjames
3 Replies
29581 Views
Last post 04-12-2021, 05:42:48
by saravanan28