[php-list] mysql optimisation

Wed, 24 May 2006 03:38:19 -0700

Can any body tell me how this query optimise?  SQL-query: EXPLAIN SELECT db.banner_id, db.banner_image, db.banner_url, db.top_banner AS TOP, dp.top_banner FROM dia_banner db, dia_page_name dp WHERE db.page_id = dp.page_id AND dp.status =1 AND dp.page_name = 'Table Talk' AND FIND_IN_SET( 'T', db.banner_align_position ) AND db.banner_start_date <= '2006-05-24' AND ( db.banner_end_date >= '2006-05-24' OR db.banner_end_date = '0000:00:00' ) ORDER BY RAND( ) ;
Rows: 2
          table   type   possible_keys   key   key_len   ref   rows   Extra     db  ALL  NULL  NULL  NULL  NULL  10  where used; Using temporary; Using filesort    dp  eq_ref  PRIMARY  PRIMARY  4  db.page_id  1  where used               

                       
---------------------------------
  Yahoo! India Answers Share what your know-how and wisdom
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now

[Non-text portions of this message have been removed]



Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list



SPONSORED LINKS
Php mysql Job postings

YAHOO! GROUPS LINKS



Reply via email to