Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- dates and index cardinality
November 22, 2005, 7:13 pm
rate this thread
different dates in a date field. If I do 'SHOW INDEXES IN TABLENAME'
the output says the cardinality of the DATE index is 568289. I take it
this is right, but other indexes in the table have cardinalities that
sort of look more in line with what I expect; DATE just appears to be
wrong. Is it? I'm trying to re-write some queries to narrow searches
quicker by using 'smaller' indexes first.
Re: dates and index cardinality
text file and poured it back into an empty form. Also dropped the index
and re-created it on the new table. Nothing changed. So I'm re-ordering
the queries anyway and chalking it up to some new internal thing in the
5.n releases (like my earlier post about mysqlcc.) Time and times will
Thanks for the reply.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum