We need more information. 1) what does "lacks" mean? 2) what did you already try? Show us the SQL you used. 3) how many rows in each table. 4) what are the table structures including indexes and constraints
On Thu, Nov 10, 2011 at 1:27 AM, Akshay Tanksale < akshay.tanksal...@gmail.com> wrote: > Hi people, > I want to make a report containing huge data of > around 20 lacks record.I did it by simple SQL but it resulted into > performance degradation.Can anybody tell me if there is any way of > solving this issue using either SQL or PL SQL? > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
