In the last episode (Sep 04), [EMAIL PROTECTED] said:
> Actually there is some requirement, where I need to know the number
> of rows that I will get for my queries before actually executing the
> query. Could you please suggest some way for this.
Your best bet is to create an index on the smallest column you can find
(maybe even create a char(1) and leave it empty), and "SELECT COUNT(*)
FROM innotable USE INDEX (smallcolumn)". That way mysql only has to
scan a small secondary index instead of the main table index.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
