Re: select query not using indexes
If your table is big, disk I/O is a bigger factor than any benefits of "fixed" size rows. Use VARCHAR unless your values are really fixed size.
I had forgotten about the ORDER BY NULL trick :)
Subject
Views
Written By
Posted
4022
June 11, 2008 01:05AM
1929
June 11, 2008 04:44AM
1918
June 15, 2008 07:44PM
1841
June 16, 2008 03:44AM
2005
June 16, 2008 06:45PM
1912
June 17, 2008 12:29AM
Re: select query not using indexes
1831
June 21, 2008 05:56PM
1784
June 23, 2008 11:20PM
1729
June 23, 2008 11:49PM
1711
June 27, 2008 01:26AM
2147
June 27, 2008 11:23PM
1892
June 18, 2008 08:22AM
Sorry, you can't reply to this topic. It has been closed.
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.