Home » RDBMS Server » Server Administration » Select statement optimization & indexes
Select statement optimization & indexes [message #375218] Mon, 06 August 2001 15:39
Laert
Messages: 20
Registered: January 2000
Junior Member
Hi,

Is there any idea how many indexes per table can use optimizer. In other words when I'm selecting some data from one table_1 and have 2 indexes first on field_1 second on filed_2 example:

select * from table_1 where field_1 = 5 and field_2 = 'ttt'

in this case is optimizer uses all indexes on table_1 or it uses only one index?

TIA
Laert

Report message to a moderator

Previous Topic: Is there any known trick to get truncated data back?
Next Topic: Date manip
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:12:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.