Optimizing perfomance using indexes

Поиск
Список
Период
Сортировка
От Vladimir Litovka
Тема Optimizing perfomance using indexes
Дата
Msg-id Pine.LNX.4.03.9810151528040.23894-100000@barnet.kharkov.ua
обсуждение исходный текст
Ответы Re: [SQL] Optimizing perfomance using indexes  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-sql
Hello!

 There are examples below and can anybody explain me - how to use indexes
 in PostgreSQL for best perfomance? Look here:

 create table aaa (num int2, name text);
 create index ax on aaa (num);

 explain select * from aaa where num = 5;
         Index Scan on aaa  (cost=0.00 size=0 width=14)

 explain select * from aaa where num > 5;
         Seq Scan on aaa  (cost=0.00 size=0 width=14)

 Why PostgreSQL in the first case uses index, but in the second - doesn't ?
 As I understand, there is no big difference between queries. Are there
 general recommendations on creating indexes?

 This questions because I'm relatively new to SQL and hope somebody can
 help me :) Thank you.

---
Vladimir Litovka <doka@webest.com>


В списке pgsql-sql по дате отправления:

Предыдущее
От: shields@crosslink.net (Michael Shields)
Дата:
Сообщение: Re: [SQL] dilemma
Следующее
От: Thomas Good
Дата:
Сообщение: Re: [SQL] Using the IN predicate in an UPDATE...