Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 32674 invoked from network); 28 Jan 2008 14:31:59 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 28 Jan 2008 14:31:59 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6E9E57F02AB; Mon, 28 Jan 2008 15:31:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08383-08; Mon, 28 Jan 2008 15:31:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D17467F0174; Mon, 28 Jan 2008 15:31:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 28 Jan 2008 14:43:25 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DC3277EFB73 for ; Mon, 28 Jan 2008 14:43:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31180-10 for ; Mon, 28 Jan 2008 14:43:24 -0500 (EST) Received: from rn-out-0102.google.com (rn-out-0910.google.com [64.233.170.191]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 84DE77EFB16 for ; Mon, 28 Jan 2008 14:43:23 -0500 (EST) Received: by rn-out-0102.google.com with SMTP id a46so184807rne.10 for ; Mon, 28 Jan 2008 11:43:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=Et1fNQooVAGgM4bKMXAOLf0oXJIkdBpSQfNiX2XBcT0=; b=Mmf4aJmDtQSrVbKNAmo9DWI4aZ9GlU59nGSNIkbfqDpIrxsPs0QxgJhcO4griUuP0nsAnkT9cFFCvTTte42Muzam/kFHaq2AvFqG6DZrtie/nkOyNeHzKC4mkPs7+NcB/59KHnxdlhbLdzjnQ7E7YHX2oud2qPgxOmjf/Xr09F4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=czdUt6WJiB4MP4j3vozqyX5QtgL6b97w3ZSq4wiQ3v9wKBl6I9E5AV/Gho5eTxMuILL16MT70sQywODIAn6wb6h3KDmUw8b5m5gjjsIRXmSj9kk8aCd0iXUvZ2QEQMEczHaN3xWj4C5CgBIW03gUBG2Btw6h9ZceFCKLOC7t8n4= Received: by 10.142.131.18 with SMTP id e18mr2644253wfd.147.1201549402918; Mon, 28 Jan 2008 11:43:22 -0800 (PST) Received: by 10.142.101.5 with HTTP; Mon, 28 Jan 2008 11:43:22 -0800 (PST) Message-ID: Date: Mon, 28 Jan 2008 20:43:22 +0100 From: "=?ISO-8859-1?Q?Bj=F8rn_D._Jensen?=" To: oracle-l@freelists.org Subject: Index only on newest partition? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13507_8307969.1201549402884" X-archive-position: 5043 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: bjorn.d.jensen@gmail.com Precedence: normal Reply-to: bjorn.d.jensen@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_13507_8307969.1201549402884 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi! If you have an huge table that is partitioned; is it possible to only have an index on the newest partition? think about the situation where users typical are intereted in the newest part, but you can live with slower performance for history data. Thanks Bjorn D. Jensen ------=_Part_13507_8307969.1201549402884 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi!
If you have an huge table that is partitioned;
is it possible to only have an index on the newest partition?
 
think about the situation where users typical are intereted in the newest part,
but you can live with slower performance for history data.
 
Thanks
Bjorn D. Jensen
------=_Part_13507_8307969.1201549402884-- -- http://www.freelists.org/webpage/oracle-l