On Thu, Oct 7, 2010 at 2:12 PM, Srikanth K <sreekanthkata@xxxxxxxxx> wrote:
Hi Can u Please let me know how can i optimize this query better. As i am attaching u the Query, Schema and Explain Analyze Report.
Plerase help me in optimizing this query.
select s.*,a.actid,a.phone,d.domid,d.domname,d.domno,a.actno,a.actname,p.descr as svcdescr from vwsubsmin s
inner join packages p on s.svcno=p.pkgno
inner join account a on a.actno=s.actno
inner join ssgdom d on a.domno=d.domno
inner join (select subsno from getexpiringsubs(1,cast('2' as integer),cast('3' as double precision),'4') as
(subsno int,expirydt timestamp without time zone,balcpt double precision)) as e on s.subsno=e.subsno
where s.status <=15 and d.domno=5
order by d.domname,s.expirydt,a.actname;
--
regards,
Srikanth Kata
--
regards,
Srikanth Kata
