Home » RDBMS Server » Server Administration » Index not use???
Index not use??? [message #373844] Tue, 15 May 2001 12:30
Robert
Messages: 43
Registered: August 2000
Member
I create two index on two tables
Like table A create index on the foreign key of the table B.
But when i make an explain plan i receive a full table scan
Why the index they not use...
I pass a script analyze table before.
my sql is (select a.id.b.id from table_a, table_b
where table_a = table_b;)

Thanks

Report message to a moderator

Previous Topic: Supressing blank spaces
Next Topic: return day of the week
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 17:17:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.