Re: [SQL] create index

[Tomasz Myrta]

Uz.ytkownik [EMAIL PROTECTED] napisa?:

i don't know how to create the index about the following statement.


SELECT b.screen_id AS screen_id, b.name AS screen_name
FROM tbl_showlog AS a CROSS JOIN
tbl_screen AS b CROSS JOIN
tbl_company AS c
WHERE a.screen_id = b.screen_id
AND b.company_id = c.company_id
AND c.company_id = 1
AND c.is_active = 1
GROUP BY b.screen_id, b.name
ORDER BY b.screen_id

Change your query to explicit joins. It looks much better and explains directly your problem.

Example:
SELECT screen_id, B.name as screen_name
FROM
tbl_company C
join tbl_screen B using (company_id)
join tbl_showlog A using (screen_id)
WHERE
company_id=1 and is_active=1


I don't know how many records do you have, but try to create indexes:
1. tbl_company -> company_id
2. tbl_screen -> company_id
3. tbl_showlog -> screen_id


Regards,
Tomasz Myrta


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html