Re: Adding index kills query
Indexes on floats can be slow.
And if there is significant proportion of nulls, slower.
IAC floats, because of rounding errors--are entirely inappropriate for storing monetary values. You should change that column to decimal of desired precision.
Edited 1 time(s). Last edit at 04/24/2014 09:38AM by Peter Brawley.
Subject
Views
Written By
Posted
2290
April 23, 2014 06:10PM
1020
April 23, 2014 06:14PM
1060
April 24, 2014 02:44AM
1205
April 24, 2014 09:07AM
1011
April 25, 2014 07:39AM
1142
April 25, 2014 11:54AM
1066
April 25, 2014 02:25PM
1110
April 28, 2014 06:06AM
Re: Adding index kills query
924
April 24, 2014 09:37AM
983
April 24, 2014 06:31PM
1269
April 24, 2014 07:10PM
1088
April 24, 2014 07:19PM
1226
April 25, 2014 10:55AM
945
April 25, 2014 11:02PM
1901
April 27, 2014 07:53PM
1026
April 27, 2014 08:50PM
1011
April 27, 2014 09:00PM
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.