MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Large database
Posted by: Omar Khan
Date: February 15, 2007 05:35AM

See that's the thing, how can we apply indexing on the count of some field say count(event_id) which keeps on changing on every insert, and also that has been used to order the fields. And ordering recordset on count requires additional temporary table.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Large database
3417
Omar Khan
January 12, 2007 07:45AM
Re: Large database
2163
Albert Arul prakash Rajendran
February 09, 2007 01:42AM
Re: Large database
2011
Omar Khan
February 14, 2007 06:55AM
Re: Large database
2179
KimSeong Loh
February 14, 2007 06:47PM
Re: Large database
2071
Omar Khan
February 15, 2007 05:35AM
Re: Large database
2199
Sean Allin
February 15, 2007 05:13PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.