Skip to Content
0
Former Member
May 13, 2010 at 03:40 AM

PERFORMENCE ISSUE OF DATA RETRIVAL FROM DATABASE

33 Views

Hello experts,

I have a requirement to retrive the data from MKPF and MSEG tables i retrived the data by writing inner join between the tables, but

this query is more expensive on database, how can i increase the performence.

Is it advisable to replace the query with view instead of join .

please suggest me.

regards

Sridhar